Anayrat links

Introduction [La théorie de la normalisation relationnelle]

sql · normalisation · not_read

March 19, 2018 at 3:52:55 PM GMT+1 * · permalink

https://stph.scenari-community.org/bdd/nor1-lin/co/nor_1.html

PostgreSQL: Speeding up analytics and windowing functions

PostgreSQL · optimizer · Window_function · Performance · sql

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

https://www.cybertec-postgresql.com/en/postgresql-speeding-up-analytics-and-windowing-functions/

create-statistics-talk/create-statistics-what-is-it.pdf at master · tvondra/create-statistics-talk · GitHub

PostgreSQL · Statistics

March 19, 2018 at 1:14:04 PM GMT+1 * · permalink

https://github.com/tvondra/create-statistics-talk/blob/master/create-statistics-what-is-it.pdf

Using pg_badplan to CREATE STATISTICS is a good plan | Joel on SQL

PostgreSQL · Statistics · pg_badplan · extension

March 19, 2018 at 1:10:40 PM GMT+1 * · permalink

https://joelonsql.com/2018/03/19/using-pg_badplan-to-create-statistics-is-a-good-plan/

Repeatable Read Is Not Repeatable – Database Journal Club – Medium

PostgreSQL · Isolation · sql

March 17, 2018 at 5:01:40 PM GMT+1 * · permalink

https://medium.com/db-journal/repeatable-read-is-not-repeatable-c700b2ce1c76

SQL/JSON standard-2016 conformance for PostgreSQL, Oracle, SQL Server and MySQL - ...

PostgreSQL · JSON

March 16, 2018 at 3:39:51 PM GMT+1 * · permalink

https://obartunov.livejournal.com/200076.html

Migrating our production deployment from MariaDB Galera to PostgreSQL and Patroni - pretix – behind the scenes - Behind the scenes of pretix, your friendly open source ticketing system from next door. Might contain traces of technology and business.

PostgreSQL · MySQL · MariaDB · Patroni · HA

March 16, 2018 at 3:27:22 PM GMT+1 * · permalink

https://behind.pretix.eu/2018/03/11/mysql-to-postgres/

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/