Anayrat links

Working with time in Postgres - Craig Kerstiens

PostgreSQL · SQL

June 10, 2017 at 8:36:59 AM GMT+2 * · permalink

http://www.craigkerstiens.com/2017/06/08/working-with-time-in-postgres/

PG Phriday: Dearly De-parted

PostgreSQL · partionning · SQL

June 10, 2017 at 8:35:28 AM GMT+2 * · permalink

https://blog.2ndquadrant.com/pg-phriday-dearly-de-parted/

eVOL Monkey: Tip for faster wal replay on a slave

PostgreSQL · Performance

June 10, 2017 at 8:35:00 AM GMT+2 * · permalink

http://evol-monkey.blogspot.fr/2017/06/tip-for-faster-wal-replay-on-slave.html

Utiliser SQL pour optimiser

SQL

June 10, 2017 at 8:32:05 AM GMT+2 * · permalink

http://pgphil.ovh/utiliser_sql_01.php

Suivre des traces dans PostgreSQL

PostgreSQL · Dtrace

June 10, 2017 at 8:30:58 AM GMT+2 * · permalink

http://www.loxodata.com/post/systemtap/

Measurements, scales and encoding schemes - Joe Celko

PostgreSQL · SQL · not_read

June 7, 2017 at 10:36:50 AM GMT+2 * · permalink

https://www.youtube.com/watch?v=95mS0v4d1M8

PostgreSQL - Don't stop the world

PostgreSQL · Internal

June 7, 2017 at 10:13:03 AM GMT+2 * · permalink

https://www.pgcon.org/2017/schedule/events/1078.en.html

GiST support in PostgreSQL

PostgreSQL · GiST

June 6, 2017 at 1:16:42 PM GMT+2 * · permalink

http://www.sai.msu.su/~megera/postgres/gist/

Async IO on Linux: select, poll, and epoll - Julia Evans

linux · Kernel · Hack

June 5, 2017 at 4:31:22 PM GMT+2 * · permalink

https://jvns.ca/blog/2017/06/03/async-io-on-linux--select--poll--and-epoll/

The Postgres Vacuum | malisper.me

PostgreSQL · Vacuum

June 5, 2017 at 4:31:09 PM GMT+2 * · permalink

http://malisper.me/the-postgres-vacuum/

Les pièges des jointures externes

PostgreSQL · join · SQL

June 5, 2017 at 4:30:51 PM GMT+2 * · permalink

http://pgphil.ovh/outer_join_96_02.php

Les jointures externes, aspects basiques

PostgreSQL · SQL · join

June 5, 2017 at 4:30:14 PM GMT+2 * · permalink

http://pgphil.ovh/outer_join_96_01.php

PostgreSQL 10 New Features

PostgreSQL · v10

June 5, 2017 at 4:29:58 PM GMT+2 * · permalink

http://h50146.www5.hpe.com/products/software/oe/linux/mainstream/support/lcc/pdf/PostgreSQL_10_New_Features_en_20170522-1.pdf

Postgres WAL | malisper.me

PostgreSQL · Internal · WAL

June 2, 2017 at 7:40:53 PM GMT+2 * · permalink

http://malisper.me/postgres-wal-log/

select * from depesz; » Blog Archive » Waiting for PostgreSQL 10 – Implement syntax for transition tables in AFTER triggers.

PostgreSQL · plpgsql

June 2, 2017 at 7:40:26 PM GMT+2 * · permalink

https://www.depesz.com/2017/06/02/waiting-for-postgresql-10-implement-syntax-for-transition-tables-in-after-triggers/

PostgreSQL + zfs - Best Practices and Standard Procedures

PostgreSQL · ZFS

June 2, 2017 at 9:06:50 AM GMT+2 * · permalink

https://people.freebsd.org/~seanc/postgresql/scale15x-2017-postgresql_zfs_best_practices.pdf

Pavel Stehule's blog: New version of PLpgSQL_check

PostgreSQL · SQL · plpgsql

June 1, 2017 at 9:57:36 PM GMT+2 * · permalink

http://okbob.blogspot.fr/2017/05/new-version-of-plpgsqlcheck.html

Partionnement et sous-partitionnement

PostgreSQL · SQL · partionning

June 1, 2017 at 9:56:51 PM GMT+2 * · permalink

http://pgphil.ovh/partition_brin_index_10_beta_02.php

Hash Index - 2

PostgreSQL · index · Hash

June 1, 2017 at 9:56:29 PM GMT+2 * · permalink

http://pgphil.ovh/hash_index_10_beta_02.php

PostgreSQL operations that you can't EXPLAIN - Felix Geisendörfer

PostgreSQL · Hack

June 1, 2017 at 9:54:21 PM GMT+2 * · permalink

http://felixge.de/2017/05/23/postgresql-operations-that-you-cant-explain.html