Anayrat links

Performance tuning: MAX and GROUP BY

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

April 10, 2024 at 13:08:52 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 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 17:55:42 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 17:55:15 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 17:54:56 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 18:24:51 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 22:13:34 GMT+2 * · permalink

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

Pitfalls of using SELECT * - Stormatics

PostgreSQL

April 3, 2024 at 17:25:04 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 17:24:34 GMT+2 * · permalink

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

SQL Logic - Simple Talk

SQL · celko

March 29, 2024 at 20:05:34 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 17:12:00 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 17:41:15 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 GMT+1 * · permalink

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

Recovering Deleted Data From PostgreSQL Tables

PostgreSQL · hack · Internal · pg_waldump

March 26, 2024 at 11:53:23 GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/recovering-deleted-data-from-postgresql-tables/

Waiting for Postgres 17: The new built-in C.UTF-8 locale

PostgreSQL · pg17 · ICU · Collation

March 23, 2024 at 13:08:16 GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-17-builtin-c-utf8-locale

Using binary-sorted indexes

PostgreSQL · pg17 · ICU · Collation

March 23, 2024 at 13:07:48 GMT+1 * · permalink

https://postgresql.verite.pro/blog/2024/03/13/binary-sorted-indexes.html

Understand PostgreSQL's Planner - Simple Scan Paths vs Plans - Highgo Software Inc.

PostgreSQL · planner · Internal

March 23, 2024 at 12:35:40 GMT+1 * · permalink

https://www.highgo.ca/2024/03/22/understand-postgresqls-planner-simple-scan-paths-vs-plans/

Postgres 17 highlight: Logical replication slots synchronization

PostgreSQL · pg17 · Replication · logique

March 18, 2024 at 17:41:59 GMT+1 * · permalink

https://bdrouvot.github.io/2024/03/16/postgres-17-highlight-logical-replication-slots-synchronization/

LabGopher :: Great server deals on eBay

serveurs

March 13, 2024 at 11:28:25 GMT+1 * · permalink

https://uk.labgopher.com/

Speed up PostgreSQL® pgvector queries with indexes | EverSQL

PostgreSQL · pgvector · vector

March 8, 2024 at 21:53:34 GMT+1 * · permalink

https://www.eversql.com/speed-up-postgresql-pgvector-queries-with-indexes/