Search: [PostgreSQL] - Anayrat links

How many engineers does it take to make subscripting work? · Erthalion's blog

PostgreSQL · pg14 · JSON · types

March 3, 2021 at 11:16:02 AM GMT+1 * · permalink

https://erthalion.info/2021/03/03/subscripting/

GitHub - microsoft/DataMigrationTeam: Repository for the Data Migration Team

Oracle · PostgreSQL · Migration · MSQLServer

March 2, 2021 at 4:29:29 PM GMT+1 * · permalink

https://github.com/microsoft/DataMigrationTeam

Migrating database storage objects from Oracle to Postgres - Microsoft Tech Community

Migration · PostgreSQL · Oracle

February 26, 2021 at 5:51:01 PM GMT+1 * · permalink

https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/migrating-database-storage-objects-from-oracle-to-postgres/ba-p/2117312

PostgreSQL TOAST Data Corruption (ERROR: unexpected chunk number) – Luca Ferrari – Open Source advocate, human being

PostgreSQL · Internal · toast

February 10, 2021 at 2:24:31 PM GMT+1 * · permalink

https://fluca1978.github.io/2021/02/08/PostgreSQLToastCorruption.html

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

PostgreSQL · not_read · index · Btree · Internal

February 1, 2021 at 4:31:10 PM GMT+1 * · permalink

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

Re-Introducing Hash Indexes in PostgreSQL | Haki Benita

PostgreSQL · index · Hash

January 18, 2021 at 5:18:15 PM GMT+1 * · permalink

https://hakibenita.com/postgresql-hash-index

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