Unlocking high-performance PostgreSQL with key memory optimizations(stormatics.tech)

82 points by camille_134 8 months ago | 5 comments

SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s(phiresky.github.io)

152 points by Maksadbek 3 years ago | 57 comments

Speeding up PostgreSQL dump/restore snapshots(xata.io)

142 points by tudorg 1 year ago | 39 comments

PostgreSQL: Effective_io_concurrency benchmarked (2019)(portavita.github.io)

32 points by akbarnama 3 years ago | 1 comments

Recent Optimizations in Python's Reference Counting(rushter.com)

16 points by f311a 9 months ago | 4 comments

Selective async commits in PostgreSQL – balancing durability and performance(shayon.dev)

89 points by shayonj 1 year ago | 29 comments

Making Postgres slower(byteofdev.com)

320 points by AsyncBanana 1 year ago | 35 comments

A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.

PostgreSQL for Everything(raphaelbauer.com)

412 points by karlmush 2 months ago | 238 comments

A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.

What I wish someone told me about Postgres(challahscript.com)

389 points by todsacerdoti 1 year ago | 161 comments

A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.

PostgreSQL and UUID as Primary Key(maciejwalkowiak.com)

387 points by taubek 2 years ago | 296 comments

A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.

Go ahead, self-host Postgres(pierce.dev)

635 points by pavel_lishin 10 months ago | 373 comments

A blog post on pierce.dev arguing that self-hosting PostgreSQL is a reasonable alternative to managed database services.

We migrated our PostgreSQL database with 11 seconds downtime(gds.blog.gov.uk)

548 points by sh_tomer 2 years ago | 189 comments

A GOV.UK Government Digital Service blog post describing how the team migrated a PostgreSQL database with only 11 seconds of downtime.