Search: [PostgreSQL] - Anayrat links

GitHub - ChenHuajun/pg_roaringbitmap: RoaringBitmap extension for PostgreSQL

RoaringBitmap · PostgreSQL

January 3, 2020 at 11:03:05 AM GMT+1 * · permalink

https://github.com/ChenHuajun/pg_roaringbitmap

PostgreSQL Internals

PostgreSQL · Internal

January 3, 2020 at 11:01:33 AM GMT+1 * · permalink

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

How to install and use pgindent · Hironobu SUZUKI @ InterDB

PostgreSQL · pgindent · hack

December 12, 2019 at 6:14:22 PM GMT+1 * · permalink

http://www.interdb.jp/blog/pgsql/pgindent/

PostgreSQL at low level: stay curious! · Erthalion's blog

PostgreSQL · BPF · bcc · perf · Internal

December 7, 2019 at 10:38:16 PM GMT+1 * · permalink

https://erthalion.info/2019/12/06/postgresql-stay-curious/

GitHub - DATA-DOG/go-sqlmock: Sql mock driver for golang to test database interactions

golang · PostgreSQL · not_read

November 28, 2019 at 6:03:13 PM GMT+1 * · permalink

https://github.com/DATA-DOG/go-sqlmock

B-tree index improvements in PostgreSQL v12 - Cybertec

pg12 · PostgreSQL · Btree · Internal · not_read

November 26, 2019 at 1:19:03 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/b-tree-index-improvements-in-postgresql-v12/

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/