Anayrat links

Updating a 50 terabyte PostgreSQL database – Adyen Tech – Medium

PostgreSQL · Upgrade

March 16, 2018 at 3:13:19 PM GMT+1 * · permalink

https://medium.com/adyen/updating-a-50-terabyte-postgresql-database-f64384b799e7

Getting Started with Patroni - OpsDash

PostgreSQL · HA · Patroni

March 16, 2018 at 3:12:08 PM GMT+1 * · permalink

https://www.opsdash.com/blog/postgres-getting-started-patroni.html

Schéma public et CVE-2018-1058

PostgreSQL · Security

March 16, 2018 at 3:11:04 PM GMT+1 * · permalink

http://blog-postgresql.verite.pro/2018/03/14/schemas-et-cve-2018-1058.html

Three reasons why VACUUM won't remove dead rows from a table - Cybertec

PostgreSQL · Vacuum

March 16, 2018 at 3:10:48 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/reasons-why-vacuum-wont-remove-dead-rows/

Database Normalization and Primary Keys

PostgreSQL · sql · normalisation

March 10, 2018 at 10:47:08 AM GMT+1 * · permalink

https://tapoueh.org/blog/2018/03/database-normalization-and-primary-keys/

Database Modelization Anti-Patterns

PostgreSQL · sql · normalisation

March 10, 2018 at 10:46:45 AM GMT+1 * · permalink

https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/

Fuzz your way to PostgreSQL (part 2)

PostgreSQL · fuzz · levenshtein · soundex · nlp

March 10, 2018 at 9:56:30 AM GMT+1 * · permalink

https://s01blog.wordpress.com/2018/03/04/fuzz-your-way-to-postgresql-part-2/

PostgreSQL and Databases in general: zheap: a storage engine to provide better control over bloat

PostgreSQL · undo · zheap

March 8, 2018 at 4:16:01 PM GMT+1 * · permalink

http://amitkapila16.blogspot.fr/2018/03/zheap-storage-engine-to-provide-better.html

The Postgres 10 feature you didn't know about: CREATE STATISTICS

PostgreSQL · Statistics

March 8, 2018 at 4:15:46 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2018/03/06/postgres-planner-and-its-usage-of-statistics/

PostgreSQL 10: a Great New Version for a Great Database | Linux Journal

PostgreSQL

March 8, 2018 at 4:15:29 PM GMT+1 * · permalink

http://www.linuxjournal.com/content/postgresql-10-great-new-version-great-database

PostgreSQL Meltdown Benchmarks |

PostgreSQL · Performance · Meltdown · Spectre

March 4, 2018 at 2:33:19 PM GMT+1 * · permalink

https://blog.2ndquadrant.com/postgresql-meltdown-benchmarks/

Barrier-enabled IO stack for Flash storage | the morning paper

storage · SSD

March 1, 2018 at 9:38:34 AM GMT+1 * · permalink

https://blog.acolyer.org/2018/02/28/barrier-enabled-io-stack-for-flash-storage/

New features for sequences: gains and pitfalls - Cybertec

PostgreSQL · sequence · sql

February 26, 2018 at 1:51:36 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/sequences-gains-and-pitfalls/

Configuring huge pages for your PostgreSQL instance, Debian version - Blog dbi services

hugepages · linux · PostgreSQL

February 26, 2018 at 9:36:25 AM GMT+1 * · permalink

https://blog.dbi-services.com/configuring-huge-pages-for-your-postgresql-instance-debian-version/

Configuring huge pages for your PostgreSQL instance, RedHat/CentOS version - Blog dbi services

hugepages · linux · PostgreSQL

February 26, 2018 at 9:35:55 AM GMT+1 * · permalink

https://blog.dbi-services.com/configuring-huge-pages-for-your-postgresql-instance-redhatcentos-version/

Fsync Performance on Storage Devices - Percona Database Performance Blog

fsync · storage · NVMe · SSD

February 26, 2018 at 9:35:27 AM GMT+1 * · permalink

https://www.percona.com/blog/2018/02/08/fsync-performance-storage-devices/

Database migrations and Pum

PostgreSQL · sql

February 23, 2018 at 2:00:16 PM GMT+1 * · permalink

http://oslandia.com/en/2018/02/23/database-migrations-and-pum/

XFS, Reflinks and Deduplication – The ongoing struggle

xfs · cow · deduplication · linux

February 23, 2018 at 12:28:02 PM GMT+1 * · permalink

http://strugglers.net/~andy/blog/2017/01/10/xfs-reflinks-and-deduplication/

When Postgres blocks: 7 tips for dealing with locks

PostgreSQL · lock · DDL · schema_migration

February 23, 2018 at 10:02:46 AM GMT+1 * · permalink

https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/

Why upgrade PostgreSQL?

PostgreSQL

February 23, 2018 at 9:52:40 AM GMT+1 * · permalink

http://why-upgrade.depesz.com