Anayrat links

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

PostgreSQL Conference - Speeding up Query Execution

PostgreSQL · Performance · JIT

May 22, 2017 at 10:43:16 PM GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/speeding-up-query-execution

PostgreSQL Conference - POWER Platform - The New Home For PostgreSQL

Performance · PostgreSQL · hardware

May 22, 2017 at 9:53:49 PM GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/power-platform-the-new-home-for-postgresql

PostgreSQL Conference - Sort vs. Hash: A Duality

slides : https://speakerdeck.com/peterg/sort-hash-pgconfus-2017

PostgreSQL · Performance · Hack

May 22, 2017 at 9:52:12 PM GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/sort-vs-hash-a-duality

PostgreSQL Conference - In-core compression: how to shrink your database size in several times

PostgreSQL · Performance · Hack

May 22, 2017 at 9:51:03 PM GMT+2 * · permalink

https://pgconf.us/conferences/2017/program/proposals/in-core-compression-how-to-shrink-your-database-size-in-several-times