Anayrat links

Transforming and Analyzing Data in PostgreSQL - Simple Talk

April 25, 2024 at 1:30:38 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/transforming-and-analyzing-data-in-postgresql/

Zero Downtime PostgreSQL Major Version Upgrades

PostgreSQL · Upgrade · logique · Replication · gitlab

April 24, 2024 at 10:07:45 PM GMT+2 * · permalink

https://postgresconf.org/system/events/document/000/002/180/2024-04-postgresconf-PostgreSQL-Zero-Downtime-Postgres-Upgrades-at-GitLab.pdf

https://postgresconf.org/system/events/document/000/002/091/pg_hint_plan_-_get_the_right_plan_without_surprises.pdf

PostgreSQL · Extension · pg_hint_plan

April 24, 2024 at 9:51:40 PM GMT+2 * · permalink

https://postgresconf.org/system/events/document/000/002/091/pg_hint_plan_-_get_the_right_plan_without_surprises.pdf

Waiting for Postgres 17: Faster B-Tree Index Scans for IN(...) lists and ANY =

PostgreSQL · skip · loose_index_scan · pg17

April 23, 2024 at 5:33:05 PM GMT+2 * · permalink

https://pganalyze.com/blog/5mins-postgres-17-faster-btree-index-scans

Recursive CTEs: Transforming and Analyzing Data in PostgreSQL, Part 3 - Simple Talk

PostgreSQL · CTE · RECURSIVE

April 22, 2024 at 1:11:45 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/recursive-ctes-transforming-and-analyzing-data-in-postgresql-part-3/

A Deeper Look Inside PostgreSQL Visibility Check Mechanism - Highgo Software Inc.

PostgreSQL · MVCC

April 21, 2024 at 9:36:24 PM GMT+2 * · permalink

https://www.highgo.ca/2024/04/19/a-deeper-look-inside-postgresql-visibility-check-mechanism/

Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2 - Simple Talk

PostgreSQL · CTE · SQL · Window_function

April 17, 2024 at 11:53:38 AM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/using-common-table-expressions-transforming-and-analyzing-data-in-postgresql-part-2/

Performance tuning: MAX and GROUP BY

PostgreSQL · SQL · skip · loose_index_scan · CTE · RECURSIVE · Lateral

April 10, 2024 at 1:08:52 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/performance-tuning/

Why CockroachDB doesn't use EvalPlanQual

PostgreSQL · MVCC · Isolation · SQL · EvalPlanQual · CockroachDB

April 6, 2024 at 10:45:55 AM GMT+2 * · permalink

https://www.cockroachlabs.com/blog/why-cockroachdb-doesnt-use-evalplanqual/

Mettre à jour PostgreSQL pour améliorer les performances

PostgreSQL · Window_function · pg15

April 5, 2024 at 5:55:42 PM GMT+2 * · permalink

http://pgphil.ovh/migration_performance_14_15_01.php

Pagination Using window-functions (OVER)

PostgreSQL · Window_function · pg15

April 5, 2024 at 5:55:15 PM GMT+2 * · permalink

https://use-the-index-luke.com/sql/partial-results/window-functions

Teach planner and executor about monotonic window funcs

PostgreSQL · Window_function · pg15 · SQL

April 5, 2024 at 5:54:56 PM GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=9d9c02ccd

A critique of ANSI SQL Isolation layers (Transaction Processing Book followup)

SQL · Isolation

April 4, 2024 at 6:24:51 PM GMT+2 * · permalink

https://muratbuffalo.blogspot.com/2024/04/a-critique-of-ansi-sql-isolation-layers.html

Everything I Know About SSDs 2019

SSD

April 3, 2024 at 10:13:34 PM GMT+2 * · permalink

https://kcall.co.uk/ssd/index.html

Pitfalls of using SELECT * - Stormatics

PostgreSQL

April 3, 2024 at 5:25:04 PM GMT+2 * · permalink

https://stormatics.tech/alis-planet-postgresql/pitfalls-of-using-select

I lost my pg_control again (... yet another data recovery story)

PostgreSQL · pg_control · Internal · hack

April 3, 2024 at 5:24:34 PM GMT+2 * · permalink

https://sdomi.pl/weblog/19-yet-another-pg-data-recovery/

SQL Logic - Simple Talk

SQL · celko

March 29, 2024 at 8:05:34 PM GMT+1 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/sql-logic/

PG Phriday: A Dirty Postgres RAG - BonesMoses.org

PostgreSQL · pgvector · vector

March 29, 2024 at 5:12:00 PM GMT+1 * · permalink

https://bonesmoses.org/2024/pg-phriday-dirty-postgres-rag/

Finding memory leaks in Postgres C code

PostgreSQL · hack · Internal · valgrind · eBPF

March 28, 2024 at 5:41:15 PM GMT+1 * · permalink

https://www.enterprisedb.com/blog/finding-memory-leaks-postgres-c-code

pg_createsubscriber: creates a new logical replica from a standby server

PostgreSQL · pg17 · Replication · logique

March 26, 2024 at 11:54:19 AM GMT+1 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=d44032d0146306971cd5ccf232fe37269717d6f2