Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL (shayon.dev) | HN Screenshots

YHacker Newsscreenshots

Screenshot of shayon.dev: Don't rely on IF NOT EXISTS for concurrent index creation in PostgreSQL

First screen, captured 2 years ago.

Looks similar

Screenshot of shayon.dev: Selective async commits in PostgreSQL – balancing durability and performance

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

89 points by shayonj 1 year ago | 29 comments

Screenshot of avi.im: PSA: SQLite WAL checksums fail silently and may lose data

PSA: SQLite WAL checksums fail silently and may lose data (avi.im)

266 points by avinassh 1 year ago | 121 comments

Screenshot of shayon.dev: A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING

A PostgreSQL planner semi-join gotcha with CTE, LIMIT, and RETURNING (shayon.dev)

49 points by namanyayg 1 year ago | 38 comments

Screenshot of fzakaria.com: Three ways to smuggle SQLite into Nix

Three ways to smuggle SQLite into Nix (fzakaria.com)

15 points by domenkozar 2 months ago | 4 comments

Screenshot of emschwartz.me: Short-Circuiting Correlated Subqueries in SQLite

Short-Circuiting Correlated Subqueries in SQLite (emschwartz.me)

6 points by emschwartz 10 months ago | 0 comments

Screenshot of shayon.dev: Scaling with PostgreSQL without boiling the ocean

Scaling with PostgreSQL without boiling the ocean (shayon.dev)

10 points by plaur782 1 year ago | 1 comments