LdS S12-2016

Je suis pas mal occupé en ce moment et j’ai du mal à tenir le rythme pour les Liens de la Semaine. Ces deux dernières semaines sont très riches en articles sur Postgres.

Notamment plusieurs articles sur la parallélisation. La 9.6 (10?) s’annonce très prometteuse!

Parallel Query Is Getting Better And Better

Parallel Aggregate – Getting the most out of your CPUs

Fin de la traduction du manuel de la 9.5

Oracle Attacks Postgres in Russia

WAITING FOR 9.6 – ADD A GENERIC COMMAND PROGRESS REPORTING FACILITY.

WAITING FOR 9.6 – ADD SIMPLE VACUUM PROGRESS REPORTING.

Add pg_visibility contrib module.

WAITING FOR 9.6 – ADD SIMPLE VACUUM PROGRESS REPORTING.

Add simple VACUUM progress reporting.

PostgreSQL 9.6 – Part 2 – Monitoring

Troubleshooting waits in PostgreSQL

Provide much better wait information in pg_stat_activity.

Don’t vacuum all-frozen pages.

No More Full-Table Vacuums

GIN indexing an array of enums

Gist and Gin support for enums

WAITING FOR 9.6 – DIRECTLY MODIFY FOREIGN TABLES.

WAITING FOR 9.6 – ADD IDLE_IN_TRANSACTION_SESSION_TIMEOUT.

Allow to trigger kernel writeback after a configurable number of writes.

Checkpoint sorting and balancing.

Allow the WAL writer to flush WAL at a reduced rate.

Ansible – Using the set_facts module