Anayrat links

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

Recovering Deleted Data From PostgreSQL Tables

PostgreSQL · hack · Internal · pg_waldump

March 26, 2024 at 11:53:23 AM 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 1:08:16 PM 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 1:07:48 PM 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 PM 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 5:41:59 PM 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 AM GMT+1 * · permalink

https://uk.labgopher.com/

Speed up PostgreSQL® pgvector queries with indexes | EverSQL

PostgreSQL · pgvector · vector

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

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

Less is More - CommandPrompt Inc.

linux · tips · tools

March 8, 2024 at 9:31:23 PM GMT+1 * · permalink

https://www.commandprompt.com/blog/less-is-more/

rest linter

python-restructuredtext_lint => rst-lint
rstcheck
sphinx-lint

rest · linter

March 7, 2024 at 4:49:12 PM GMT+1 * · permalink

/shaare/LLOXIQ