This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.
⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.
Jimmy Zhuo zhuomingliang
zhuomingliang
/ PostgreSQL-EXTENSIONs.md
Created
December 19, 2022 03:43
— forked from joelonsql/PostgreSQL-EXTENSIONs.md
1000+ PostgreSQL EXTENSIONs
zhuomingliang
/ benchmarking.md
Created
October 28, 2021 13:27
— forked from saurabhnanda/benchmarking.md
ZFS underperforms EXT4 significantly
- With the default settings that ship with Postgres, ZFS underperforms EXT4 by a factor of 2-3x.
- Most notable setting is
shared_buffers=128MB
- Most notable setting is
- When benchmarks are running on ZFS, severe write amplification is reported by
iotopandtxg_syncis performing a lot of IO. Example: - The DB used for benchmarking is ~30GB. The system has a total of 64GB RAM with the ARC being given a maximum of ~32GB. Irrespective of the small value of
shared_buffers, almost the entire DB should be cached in the ARC and the ZFS benchmark should not suffer so greatly.
zhuomingliang
/ tuning-postgres-zfs.md
Created
October 28, 2021 13:27
— forked from saurabhnanda/tuning-postgres-zfs.md
Tuning Postgres + ZFS
Please refer to ZFS 2-3x slower than EXT4 to see how ZFS defaults + Postgres defaults severely underperform EXT4 defaults + Postgres defaults (and also to know more about the system on which these benchmarks were performed). This page documents how to tune ZFS + Postgres to give better performance for the tpcb-like benchmark.
Please do not copy these settings blindly because I am myself not clear on why/how these settings had the impact they did. For example, I cannot explain why full_page_writes=off independently did not give that much boost, nor did an optimized PG configuration. However, putting both of them together gave a 2-4x boost compared to baseline numbers.
zhuomingliang
/ psql_useful_stat_queries.sql
Created
April 17, 2019 08:05
— forked from anvk/psql_useful_stat_queries.sql
List of some useful Stat Queries for PSQL
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md | |
| --- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192 | |
| -- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB. | |
| ------------ | |
| -- Basics -- | |
| ------------ | |
| -- Get indexes of tables |
zhuomingliang
/ statistics.sql
Created
April 17, 2019 08:02
— forked from ruckus/statistics.sql
Postgres statistics queries
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ** Find commmonly accessed tables and their use of indexes: | |
| SELECT relname,seq_tup_read,idx_tup_fetch,cast(idx_tup_fetch AS numeric) / (idx_tup_fetch + seq_tup_read) AS idx_tup_pct FROM pg_stat_user_tables WHERE (idx_tup_fetch + seq_tup_read)>0 ORDER BY idx_tup_pct; | |
| Returns output like: | |
| relname | seq_tup_read | idx_tup_fetch | idx_tup_pct | |
| ----------------------+--------------+---------------+------------------------ | |
| schema_migrations | 817 | 0 | 0.00000000000000000000 | |
| user_device_photos | 349 | 0 | 0.00000000000000000000 |
zhuomingliang
/ OpenSimplexNoise.java
Created
January 22, 2019 11:39
— forked from KdotJPG/OpenSimplex2S.java
Visually axis-decorrelated coherent noise algorithm based on the Simplectic honeycomb.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * OpenSimplex Noise in Java. | |
| * by Kurt Spencer | |
| * | |
| * v1.1 (October 5, 2014) | |
| * - Added 2D and 4D implementations. | |
| * - Proper gradient sets for all dimensions, from a | |
| * dimensionally-generalizable scheme with an actual | |
| * rhyme and reason behind it. | |
| * - Removed default permutation array in favor of |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * fork.c | |
| * Experimental fork() on Windows. Requires NT 6 subsystem or | |
| * newer. | |
| * | |
| * Copyright (c) 2012 William Pitcock <[email protected]> | |
| * | |
| * Permission to use, copy, modify, and/or distribute this software for any | |
| * purpose with or without fee is hereby granted, provided that the above | |
| * copyright notice and this permission notice appear in all copies. |
zhuomingliang
/ gist:e923744cca64acf46fdde787059e3adc
Created
December 10, 2018 16:42
— forked from juniorb2ss/gist:1bc2e1fc25c17f7b03262a735d063d3a
Commands to ElasticBeanstalk
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| commands: | |
| 00_update_composer: | |
| command: export HOME=/root && export COMPOSER_HOME=/root && /usr/bin/composer.phar self-update | |
| option_settings: | |
| - namespace: aws:elasticbeanstalk:application:environment | |
| option_name: COMPOSER_HOME | |
| value: /root | |
| - namespace: aws:elasticbeanstalk:application:environment | |
| option_name: HOME |
zhuomingliang
/ postgresql_kmeans.sql
Created
November 3, 2018 08:45
— forked from thiagomata/postgresql_kmeans.sql
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Based on the mysql cluster | |
| * @link http://jonisalonen.com/2012/k-means-clustering-in-mysql/ | |
| */ | |
| -- SELECT | |
| -- * FROM | |
| -- unnest(kmeans(array(SELECT | |
| -- ( | |
| -- lat, |
zhuomingliang
/ example.sql
Created
November 1, 2018 10:03
— forked from marcocitus/example.sql
Safe incremental rollups on Postgres and Citus
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Create the raw events table | |
| CREATE TABLE page_views ( | |
| site_id int, | |
| path text, | |
| client_ip inet, | |
| view_time timestamptz default now(), | |
| view_id bigserial | |
| ); | |
| -- Allow fast lookups of ranges of sequence IDs |
NewerOlder