Search: [PostgreSQL] - Anayrat links

My Postgres Trail: Investigating bulk load operation in partitioned tables

PostgreSQL · partionning · performance

November 25, 2019 at 6:12:55 PM GMT+1 * · permalink

https://mbeena-learnings.blogspot.com/2019/11/investigating-bulk-load-operation-in_14.html

Transactions in PostgreSQL and other animals - Speaker Deck

PostgreSQL · Internal · hack · xact

November 5, 2019 at 1:44:32 PM GMT+1 * · permalink

https://speakerdeck.com/macdice/transactions-in-postgresql-and-other-animals

Instantaneous transaction rollback, and other advantages of versioned storage

PostgreSQL · MVCC · Btree

October 17, 2019 at 3:13:32 PM GMT+2 * · permalink

https://speakerdeck.com/peterg/xact-rollback-pgconfeu

GitHub - lfittl/pg_query_go: Go library to parse and normalize SQL queries using the PostgreSQL query parser

golang · SQL · PostgreSQL · parser

October 15, 2019 at 12:31:19 PM GMT+2 * · permalink

https://github.com/lfittl/pg_query_go

Nondeterministic collations

PostgreSQL · ICU · Collation

October 14, 2019 at 10:53:45 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2019/10/14/nondeterministic-collations.html

Better guidance for database developers

PostgreSQL · linux · storage · Internal

September 28, 2019 at 11:39:08 AM GMT+2 * · permalink

https://lwn.net/Articles/799807/

Evaluate Odyssey as a replacement for pgbouncer(s) (#7776) · Issues · GitLab.com / GitLab Infrastructure Team / infrastructure · GitLab

odyssey · PostgreSQL · PgBouncer

September 6, 2019 at 9:53:39 AM GMT+2 * · permalink

https://gitlab.com/gitlab-com/gl-infra/infrastructure/issues/7776

RCA: 2019-08-20 Elevated web latency (#7632) · Issues · GitLab.com / GitLab Infrastructure Team / infrastructure · GitLab

PgBouncer · odyssey · PostgreSQL

September 6, 2019 at 9:53:10 AM GMT+2 * · permalink

https://gitlab.com/gitlab-com/gl-infra/infrastructure/issues/7632

Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP - Cybertec

PostgreSQL · SQL · Window_function

August 17, 2019 at 9:23:15 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/timeseries-exclude-ties-current-row-and-group/

Doubling the Sorting Speed of Postgres Network Types with Abbreviated Keys — Brandur Leach

PostgreSQL · sort

August 7, 2019 at 11:07:23 PM GMT+2 * · permalink

https://brandur.org/sortsupport-inet

Using Docker Hub PostgreSQL images - 2ndQuadrant | PostgreSQL

PostgreSQL · Docker

August 3, 2019 at 3:38:52 PM GMT+2 * · permalink

https://www.2ndquadrant.com/en/blog/using-docker-hub-postgresql-images/

Standby in production: scaling application in the second largest classified site in the world

PostgreSQL · Replication

July 25, 2019 at 4:29:39 PM GMT+2 * · permalink

https://medium.com/avitotech/standby-in-production-scaling-application-in-second-largest-classified-site-in-the-world-97a79a1929de

Fsyncgate: errors on fsync are unrecovarable

linux · PostgreSQL · Kernel

July 25, 2019 at 4:29:04 PM GMT+2 * · permalink

https://danluu.com/fsyncgate/

PostgreSQL's indexes - GIN algorithms | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · GIN · index

July 2, 2019 at 6:14:24 PM GMT+2 * · permalink

http://www.louisemeta.com/blog/indexes-gin-algorithms/

PostgreSQL's indexes - GIN | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · GIN · index

July 2, 2019 at 6:14:11 PM GMT+2 * · permalink

http://www.louisemeta.com/blog/indexes-gin/

Postgres 12 highlight - SQL/JSON path

PostgreSQL · pg12 · JSON

June 21, 2019 at 10:27:14 AM GMT+2 * · permalink

https://paquier.xyz/postgresql-2/postgres-12-jsonpath/

Linear Interpolation with PostgreSQL

SQL · PostgreSQL · Statistics

June 15, 2019 at 11:58:17 AM GMT+2 * · permalink

https://bytefish.de/blog/postgresql_interpolation/

Amit Langote - Postgres: Caches and Invalidation

PostgreSQL · hack · Internal · Cache

June 14, 2019 at 4:25:32 PM GMT+2 * · permalink

https://amitlan.github.io/writing/pginval.html

Indexes in PostgreSQL — 10 (Bloom) / Postgres Professional corporate blog / Habr

PostgreSQL · index · Bloom

June 11, 2019 at 11:59:21 AM GMT+2 * · permalink

https://habr.com/en/company/postgrespro/blog/452968/

Postgres 12 highlight - Table Access Methods and blackholes

PostgreSQL · Internal · hack · table_am

June 4, 2019 at 12:21:51 PM GMT+2 * · permalink

https://paquier.xyz/postgresql-2/postgres-12-table-am-blackhole/