Anayrat links

Bruce Momjian: Column Storage Internals

PostgreSQL · Internal · Hack

March 17, 2017 at 6:12:42 PM GMT+1 * · permalink

http://momjian.us/main/blogs/pgblog/2017.html#March_15_2017

Removing A Lot of Old Data (But Keeping Some Recent) at Keith's Ramblings…

PostgreSQL

March 17, 2017 at 6:12:16 PM GMT+1 * · permalink

https://www.keithf4.com/removing-old-data/

IPv6 sur Dedibox par dhclient

IPv6

March 17, 2017 at 6:11:58 PM GMT+1 * · permalink

http://www.dsfc.net/infrastructure/reseau/ipv6-sur-dedibox-par-dhclient/

PostgreSQL and Databases in general: Hash indexes are faster than Btree indexes?

PostgreSQL · Hash · Btree · index

March 17, 2017 at 6:11:36 PM GMT+1 * · permalink

http://amitkapila16.blogspot.fr/2017/03/hash-indexes-are-faster-than-btree.html

PG Phriday: RESTing in the Corn | BonesMoses.org

PostgreSQL · Multicorn · JSON · Python

March 17, 2017 at 6:11:10 PM GMT+1 * · permalink

http://bonesmoses.org/2017/03/17/pg-phriday-resting-in-the-corn/

Gallery of Processor Cache Effects

processor · Cache

March 16, 2017 at 4:04:49 PM GMT+1 * · permalink

http://igoro.com/archive/gallery-of-processor-cache-effects/

Examples of palloc overhead | PostgreSQL Addict

Internal · PostgreSQL

March 16, 2017 at 4:02:53 PM GMT+1 * · permalink

http://blog.pgaddict.com/posts/palloc-overhead-examples

Allocation Set internals | PostgreSQL Addict

Internal · PostgreSQL

March 16, 2017 at 4:02:38 PM GMT+1 * · permalink

http://blog.pgaddict.com/posts/allocation-set-internals

Getting started with JSONB in Postgres - Craig Kerstiens

PostgreSQL · JSON

March 12, 2017 at 11:23:17 PM GMT+1 * · permalink

http://www.craigkerstiens.com/2017/03/12/getting-started-with-jsonb-in-postgres/

Router son bloc IPv6 /48 pour ses VMs chez online.net

IPv6

March 11, 2017 at 9:04:53 PM GMT+1 * · permalink

https://www.swordarmor.fr/router-son-bloc-ipv6-48-pour-ses-vms-chez-onlinenet.html

Wildcard query for jsonb - ...

PostgreSQL · JSON

March 11, 2017 at 8:56:18 PM GMT+1 * · permalink

http://obartunov.livejournal.com/193870.html

PG Phriday: Stuck in the Middle with Postgres | BonesMoses.org

PostgreSQL · FDW

March 10, 2017 at 7:34:27 PM GMT+1 * · permalink

http://bonesmoses.org/2017/03/10/pg-phriday-stuck-in-the-middle-with-postgres/

Postgres 10 highlight - SCRAM authentication

PostgreSQL

March 9, 2017 at 1:59:15 PM GMT+1 * · permalink

http://paquier.xyz/postgresql-2/postgres-10-scram-authentication/

Impress Your Coworkers With the Incredible NATURAL FULL OUTER JOIN! – Java, SQL and jOOQ.

SQL

March 7, 2017 at 1:56:46 PM GMT+1 * · permalink

https://blog.jooq.org/2017/03/07/impress-your-coworkers-with-a-sql-natural-full-outer-join/

Jeremy Raines - 7 More Useful SQL and/or Postgres Techniques

PostgreSQL · SQL

March 7, 2017 at 1:52:54 PM GMT+1 * · permalink

http://jeremyraines.com/2016/10/11/7-more-useful-sql-and-or-postgres-techniques.html

Data Egret: Deep dive into postgres stats: pg_stat_bgwriter

PostgreSQL · Statistics · pg_stat_bgwriter

March 7, 2017 at 1:52:20 PM GMT+1 * · permalink

http://blog.postgresql-consulting.com/2017/03/deep-dive-into-postgres-stats.html

Writing Postgres Extensions Code Organization and Versioning - Big elephants

PostgreSQL · Extension · Hack

March 4, 2017 at 11:06:40 AM GMT+1 * · permalink

http://big-elephants.com/2015-11/writing-postgres-extensions-part-v/

Writing Postgres Extensions - Testing - Big elephants

PostgreSQL · Extension · Hack

March 4, 2017 at 11:03:00 AM GMT+1 * · permalink

http://big-elephants.com/2015-11/writing-postgres-extensions-part-iv/

Writing Postgres Extensions - Debugging - Big elephants

PostgreSQL · Extension · Hack

March 4, 2017 at 10:56:44 AM GMT+1 * · permalink

http://big-elephants.com/2015-10/writing-postgres-extensions-part-iii/

Writing Postgres Extensions - Types and Operators - Big elephants

Extension · PostgreSQL · Hack

March 4, 2017 at 10:50:28 AM GMT+1 * · permalink

http://big-elephants.com/2015-10/writing-postgres-extensions-part-ii/