Anayrat links

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

Tuning Input/Output (I/O) Operations for PostgreSQL | Severalnines

PostgreSQL · Performance

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

https://severalnines.com/blog/tuning-io-operations-postgresql

Fun with SQL: Functions in Postgres

PostgreSQL · sql

June 22, 2018 at 8:20:01 AM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/21/fun-with-sql-functions/

Robert Haas: Using force_parallel_mode Correctly

PostgreSQL · Parallel

June 21, 2018 at 5:55:30 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2018/06/using-forceparallelmode-correctly.html

Missing Data - Simple Talk

sql · celko

June 20, 2018 at 11:08:53 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/sql/sql-development/missing-data-2/

Procédures

PostgreSQL · sql · procedure

June 17, 2018 at 2:14:18 PM GMT+2 * · permalink

http://pgphil.ovh/procedure_11_beta_01.php

GitHub - djrobstep/migra: Like diff but for PostgreSQL schemas

PostgreSQL · schema

June 15, 2018 at 7:55:34 PM GMT+2 * · permalink

https://github.com/djrobstep/migra

Scalable incremental data aggregation on Postgres and Citus

PostgreSQL · sql · citus · Aggregate

June 14, 2018 at 9:52:50 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/14/scalable-incremental-data-aggregation/

Configuring memory for Postgres

PostgreSQL

June 12, 2018 at 10:03:01 PM GMT+2 * · permalink

https://www.citusdata.com/blog/2018/06/12/configuring-work-mem-on-postgres/

Index creation can make SELECT performance worse - Cybertec

PostgreSQL · optimizer · index

June 12, 2018 at 8:20:34 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/index-decreases-select-performance/

zheap: less bloat, fewer writes, and just plain smaller

zheap · PostgreSQL

June 7, 2018 at 11:17:27 AM GMT+2 * · permalink

http://www.pgcon.org/2018/schedule/attachments/501_zheap-a-new-storage-format-postgresql-5.pdf

What’s in a Plan?

PostgreSQL · Internal · planner

June 7, 2018 at 11:16:17 AM GMT+2 * · permalink

http://www.pgcon.org/2018/schedule/attachments/502_What's%20In%20a%20Plan.pdf

Faire société : le choix des coopératives - La Manufacture coopérative

SCOP

June 6, 2018 at 3:43:04 PM GMT+2 * · permalink

http://manufacture.coop/faire-societe-choix-cooperatives/

Recovery use cases for Logical Replication in PostgreSQL 10

PostgreSQL · Replication · logique · londiste

June 6, 2018 at 2:17:33 PM GMT+2 * · permalink

https://medium.com/avitotech/recovery-use-cases-for-logical-replication-in-postgresql-10-a1e6bab03072