Anayrat links

pg_prefaulter: Scaling WAL Performance

pg_prefaulter · PostgreSQL · Replication

June 30, 2018 at 12:04:08 PM GMT+2 * · permalink

https://www.slideshare.net/SeanChittenden/pgprefaulter-scaling-wal-performance

Présentation PostgreSQL et ICU

PostgreSQL · Collation · ICU

June 30, 2018 at 10:08:52 AM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2018/06/29/presentation-pg-icu.html

Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect - Percona Database Performance Blog

PostgreSQL · pooler · PgBouncer

June 30, 2018 at 9:58:48 AM GMT+2 * · permalink

https://www.percona.com/blog/2018/06/27/scaling-postgresql-with-pgbouncer-you-may-need-a-connection-pooler-sooner-than-you-expect/

Faster Point In Time Recovery (PITR) in PostgreSQL Using a Delayed Standby - Percona Database Performance Blog

PostgreSQL · Replication

June 30, 2018 at 9:58:30 AM GMT+2 * · permalink

https://www.percona.com/blog/2018/06/28/faster-point-in-time-recovery-pitr-postgresql-using-delayed-standby/

PostgreSQL Tuning: Key Things to Drive Performance | Severalnines

PostgreSQL · Performance

June 29, 2018 at 2:15:47 PM GMT+2 * · permalink

https://severalnines.com/blog/postgresql-tuning-key-things-drive-performance

Serment d'Hippocrate pour Data Scientist

June 29, 2018 at 12:05:43 PM GMT+2 * · permalink

https://www.hippocrate.tech

Data for Good x Bayes Impact

June 29, 2018 at 12:05:31 PM GMT+2 * · permalink

http://www.dataforgood.fr

How not to structure your database-backed web applications: a study of performance bugs in the wild

Publication · database

June 29, 2018 at 12:01:50 PM GMT+2 * · permalink

https://hyperloop-rails.github.io/220-HowNotStructure.pdf

Pg11 pgday 2018

PostgreSQL

June 29, 2018 at 12:01:06 PM GMT+2 * · permalink

https://www.slideshare.net/JeanChristopheArnu/pg11-pgday-2018

Postgres 11 highlight - New System Roles

PostgreSQL · roles

June 29, 2018 at 10:45:37 AM GMT+2 * · permalink

https://paquier.xyz/postgresql-2/postgres-11-new-system-roles/

Portable Services with systemd v239

systemd · linux

June 29, 2018 at 10:44:35 AM GMT+2 * · permalink

http://0pointer.net/blog/walkthrough-for-portable-services.html

Introduction to Data Vault Modeling

modelisation · sql · data_vault · not_read

June 29, 2018 at 10:39:49 AM GMT+2 * · permalink

https://fr.slideshare.net/kgraziano/introduction-to-data-vault-modeling

Default Partition - Adopting the Odds | EnterpriseDB

PostgreSQL · partionning

June 29, 2018 at 10:37:35 AM GMT+2 * · permalink

https://www.enterprisedb.com/blog/default-partition-adopting-odds

Optimizing queries on TimescaleDB hypertables with thousands of partitions

PostgreSQL · TimescaleDB

June 29, 2018 at 10:37:10 AM GMT+2 * · permalink

https://blog.timescale.com/optimizing-queries-timescaledb-hypertables-with-partitions-postgresql-6366873a995d

PostgreSQL Concurrency: Data Modification Language

PostgreSQL · sql

June 26, 2018 at 9:40:26 AM GMT+2 * · permalink

https://tapoueh.org/blog/2018/06/postgresql-concurrency-data-modification-language/

Improve run-time partition pruning to handle any stable expression.

PostgreSQL · partition_pruning · partionning

June 26, 2018 at 9:39:54 AM GMT+2 * · permalink

https://www.depesz.com/2018/06/25/waiting-for-postgresql-11-improve-run-time-partition-pruning-to-handle-any-stable-expression/

Walking with the Elephant: Planning queries involving foreign PostgreSQL tables

PostgreSQL · planner · FDW

June 23, 2018 at 10:26:56 AM GMT+2 * · permalink

http://ashutoshpg.blogspot.com/2018/06/planning-queries-involving-foreign.html

Upgrade your partitioning from inheritance to declarative

PostgreSQL · partionning

June 23, 2018 at 10:26:31 AM GMT+2 * · permalink

http://ashutoshpg.blogspot.com/2018/06/upgrade-your-partitioning-from.html

Using Cryptographic Hardware to Secure Applications

PostgreSQL · Crypto

June 22, 2018 at 2:22:05 PM GMT+2 * · permalink

https://momjian.us/main/writings/crypto_hw_use.pdf

Scaling Postgres at Affinity with Citus

PostgreSQL · Performance · citus

June 22, 2018 at 2:21:28 PM GMT+2 * · permalink

https://build.affinity.co/scaling-postgres-at-affinity-with-citus-bc93bb7f4441