Anayrat links

Speeding Up Foreign Key Constraints During Migrations

PostgreSQL · fk

November 3, 2024 at 6:40:33 PM GMT+1 * · permalink

https://dev.to/yugabyte/speeding-up-foreign-key-constraints-during-migrations-3a9o

⚡ pgdoc.link ⚡

PostgreSQL · doc

October 30, 2024 at 9:39:46 AM GMT+1 * · permalink

https://pgdoc.link/

https://www.kernel.org/doc/Documentation/device-mapper/cache.txt

LVM · Cache · linux · Kernel

October 25, 2024 at 4:07:34 PM GMT+2 * · permalink

https://www.kernel.org/doc/Documentation/device-mapper/cache.txt

LVM Cache Modes and Behavior

LVM · Cache · linux · Kernel

October 25, 2024 at 4:07:13 PM GMT+2 * · permalink

https://lucaswerkmeister.de/posts/2022/07/03/lvmcache/

Talking Postgres with Claire Giordano | How I got started as a developer (& in Postgres) with Tom Lane

PostgreSQL · podcast

October 17, 2024 at 9:37:16 PM GMT+2 * · permalink

https://share.transistor.fm/s/8e643aed

Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints – select * from depesz;

PostgreSQL · PERIOD · pg18

October 7, 2024 at 5:32:08 PM GMT+2 * · permalink

https://www.depesz.com/2024/10/03/waiting-for-postgresql-18-add-temporal-foreign-key-contraints/

Contraintes temporelles dans PostgreSQL 18

PostgreSQL · pg18

October 2, 2024 at 8:13:26 PM GMT+2 * · permalink

https://blog.dalibo.com/2024/10/01/postgresql-18-contraintes-temporelles.html

PostgreSQL and Databases in general: Online Upgrading Logical and Physical Replication Nodes

pg17 · PostgreSQL · Upgrade · logique · Replication

September 26, 2024 at 4:04:57 PM GMT+2 * · permalink

http://amitkapila16.blogspot.com/2024/09/online-upgrading-logical-and-physical.html

Framalab’s Stirling PDF

pdf

September 26, 2024 at 2:14:54 PM GMT+2 * · permalink

https://stirling-pdf.framalab.org/

Rounding Numbers - Simple Talk

SQL · celko · not_read

September 23, 2024 at 2:02:16 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/rounding-numbers/

https://www.hagander.net/talks/PostgreSQL%2017.pdf

PostgreSQL · pg17

September 16, 2024 at 11:11:37 PM GMT+2 * · permalink

https://www.hagander.net/talks/PostgreSQL%2017.pdf

Ma config MPV 2024 // /home/lord

mpv

September 15, 2024 at 9:51:07 AM GMT+2 * · permalink

https://lord.re/posts/250-meilleure-config-mpv-2024/

Postgres Planner Quirks: JOIN Equivalence Classes and IN/ANY filters

PostgreSQL · planner · Join · optimizer

September 12, 2024 at 10:51:22 PM GMT+2 * · permalink

https://pganalyze.com/blog/5mins-postgres-planner-join-equivalence-class-in-any-filters

Uniqueness, Keys, and Identity - Simple Talk

SQL · not_read · celko

September 11, 2024 at 8:40:02 PM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/theory-and-design/uniqueness-keys-and-identity/

PGSQL Phriday #015: Primary keys: UUID, CUID, or TSID? | My DBA Notebook

uuid · ulid · PostgreSQL

September 6, 2024 at 3:56:41 PM GMT+2 * · permalink

https://mydbanotebook.org/posts/pgsql-phriday-%23015-primary-keys-uuid-cuid-or-tsid/

What's New for Developer's in PostgreSQL 17

PostgreSQL · pg17

September 3, 2024 at 10:32:46 PM GMT+2 * · permalink

https://docs.google.com/presentation/d/1tdqYFHBdkIHVSZNEmh2ZvJPmusoucje-5eyZu-7Lo5I/edit#slide=id.g2e06aaddb08_0_164

How to Get or Create in PostgreSQL | Haki Benita

PostgreSQL · not_read

August 12, 2024 at 12:50:31 PM GMT+2 * · permalink

https://hakibenita.com/postgresql-get-or-create

Talking Postgres with Claire Giordano | How I got started as a developer (& in Postgres) with David Rowley

PostgreSQL · not_read

August 12, 2024 at 12:49:25 PM GMT+2 * · permalink

https://share.transistor.fm/s/35ba396b

Robert Haas: Posting Your Patch On pgsql-hackers

PostgreSQL · not_read · hack

August 12, 2024 at 12:48:52 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2024/08/posting-your-patch-on-pgsql-hackers.html

Robert Haas: PostgreSQL Hacking Workshop - August 2024

PostgreSQL · not_read

August 4, 2024 at 5:10:38 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2024/07/postgresql-hacking-workshop-august-2024.html