Hacker News Reader

Missing a fun one: ctid

Yes! Actually, I was thinking "WAL" is constantly thrown around without explanation too.

pg_stat_activity

ctid gives me ptsd !

ya. i use them when I need to delete duplicates and there is no pk.

Ohh. I always used row_number for that.