Search: [PostgreSQL] - Anayrat links

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

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

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

PostgreSQL 11: Instant add column with a non null default value - Blog dbi services

PostgreSQL · sql

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

https://blog.dbi-services.com/postgresql-11-instant-add-column-with-a-non-null-default-value/

Pivots statiques et dynamiques

PostgreSQL · sql · plpgsql

June 4, 2018 at 9:41:37 AM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2018/06/02/crosstab-pivot.html

Measure the impact of DRBD on your PostgreSQL database thanks to pgio (the SLOB method for PostgreSQL) – bdt's blog

PostgreSQL · pgio

June 4, 2018 at 9:41:25 AM GMT+2 * · permalink

https://bdrouvot.wordpress.com/2018/06/02/measure-the-impact-of-drbd-on-your-postgresql-database-thanks-to-pgio-the-slob-method-for-postgresql/