Search: [PostgreSQL] - Anayrat links

Some SQL Tricks of an Application DBA | Haki Benita

Tricks · PostgreSQL · SQL

January 15, 2021 at 3:08:19 PM GMT+1 * · permalink

https://hakibenita.com/sql-tricks-application-dba

Evolution of tree data structures for indexing: more exciting than it sounds · Erthalion's blog

PostgreSQL · sort · Btree · Algorithm · index · Research

December 28, 2020 at 5:14:31 PM GMT+1 * · permalink

https://erthalion.info/2020/11/28/evolution-of-btree-index-am/

Don't let collation versions corrupt your PostgreSQL indexes - Microsoft Tech Community

PostgreSQL · index · ICU · Collation

December 14, 2020 at 3:59:38 PM GMT+1 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/don-t-let-collation-versions-corrupt-your-postgresql-indexes/ba-p/1978394

GitHub - hyrise/index_selection_evaluation: Platform to evaluate index selection algorithms

PostgreSQL · hypopg · index

October 14, 2020 at 3:26:59 PM GMT+2 * · permalink

https://github.com/hyrise/index_selection_evaluation

Indexes in PostgreSQL — 10 (Bloom) : Postgres Professional

PostgreSQL · index · Bloom

October 9, 2020 at 5:11:53 PM GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/5967832

Indexes in PostgreSQL — 9 (BRIN) : Postgres Professional

PostgreSQL · index · BRIN

October 1, 2020 at 3:44:12 PM GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/5967830

Indexes in PostgreSQL — 8 (RUM) : Postgres Professional

PostgreSQL · index · RUM

September 30, 2020 at 10:47:39 AM GMT+2 * · permalink

https://postgrespro.com/blog/pgsql/4262305

PostgreSQL13 New Features

pg13 · PostgreSQL

June 3, 2020 at 4:24:02 PM GMT+2 * · permalink

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

GitHub - kryonix/pg_cuckoo: Use PostgreSQL's planner hook to open a side entrance through which we can pass plan trees for immediate execution

PostgreSQL · hack · Internal · planner

May 28, 2020 at 3:58:57 PM GMT+2 * · permalink

https://github.com/kryonix/pg_cuckoo

Bottom-up Join Enumeration in a Top-down Optimizer

Greenplum · orca · optimizer · planner · PostgreSQL · not_read

May 15, 2020 at 9:22:10 AM GMT+2 * · permalink

https://greenplum.org/bottom-up-join-enumeration-in-a-top-down-optimizer/

Parallelism in PostgreSQL: treatment of trees and conscience / Postgres Professional corporate blog / Habr

PostgreSQL · lock · spinlock · pg_locks · Internal · numa

May 13, 2020 at 3:29:03 PM GMT+2 * · permalink

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

GitHub - k1LoW/tbls: tbls is a CI-Friendly tool for document a database, written in Go.

PostgreSQL · golang

May 11, 2020 at 3:10:39 PM GMT+2 * · permalink

https://github.com/k1LoW/tbls

What is Baked in the Baker's Dozen? / Postgres Professional corporate blog / Habr

PostgreSQL · pg13

May 1, 2020 at 8:42:14 PM GMT+2 * · permalink

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

Choosing PostgreSQL Bloom Index Parameters

PostgreSQL · Bloom

February 12, 2020 at 4:03:37 PM GMT+1 * · permalink

http://blog.coelho.net/database/2016/12/11/postgresql-bloom-index.html

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/