Anayrat links

MultiXacts in PostgreSQL: usage, side effects, and monitoring | AWS Database Blog

PostgreSQL · multixact

November 19, 2024 at 12:16:47 GMT+1 * · permalink

https://aws.amazon.com/fr/blogs/database/multixacts-in-postgresql-usage-side-effects-and-monitoring/

Home page | NKON

battery · lithium

November 3, 2024 at 20:09:06 GMT+1 * · permalink

https://eu.nkon.nl/

Speeding Up Foreign Key Constraints During Migrations

PostgreSQL · fk

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

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

⚡ pgdoc.link ⚡

PostgreSQL · doc

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

https://pgdoc.link/

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

LVM · Cache · linux · Kernel

October 25, 2024 at 16:07:34 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 16:07:13 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 21:37:16 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 17:32:08 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 20:13:26 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 16:04:57 GMT+2 * · permalink

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

Framalab’s Stirling PDF

pdf

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

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

Rounding Numbers - Simple Talk

SQL · celko · not_read

September 23, 2024 at 14:02:16 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 23:11:37 GMT+2 * · permalink

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

Ma config MPV 2024 // /home/lord

mpv

September 15, 2024 at 09:51:07 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 22:51:22 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 20:40:02 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 15:56:41 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 22:32:46 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 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 GMT+2 * · permalink

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