Anayrat links

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

ALTER INDEX ... SET STATISTICS ...??? - Alexander Korotkov's blog

PostgreSQL · Performance

June 1, 2017 at 9:46:15 PM GMT+2 * · permalink

http://akorotkov.github.io/blog/2017/05/31/alter-index-weird/

NVME PCIe 10GB/s KaiGai

SSD · NVMe

June 1, 2017 at 9:45:34 PM GMT+2 * · permalink

http://kaigai.hatenablog.com/entry/2017/05/28/194938

Les branches if/else/endif dans psql (PostgreSQL 10)

PostgreSQL · psql

May 24, 2017 at 8:31:19 AM GMT+2 * · permalink

http://blog-postgresql.verite.pro/2017/05/23/psql-conditions.html

Cuckoo Filter: Practically Better Than Bloom

Cuckoo · Bloom · compression

May 24, 2017 at 8:30:22 AM GMT+2 * · permalink

https://www.cs.cmu.edu/~dga/papers/cuckoo-conext2014.pdf

Simple SQL: Attribute Splitting - Simple Talk - Joe Celko

SQL

May 23, 2017 at 1:16:10 PM GMT+2 * · permalink

https://www.simple-talk.com/sql/t-sql-programming/simple-sql-attribute-splitting/

PostgreSQL Conference - Moving PostgreSQL Forward

PostgreSQL · Hack

May 23, 2017 at 1:13:00 PM GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/moving-postgresql-forward