Postgres Insider Terminology

Re:Postgres Insider Terminology by ryandotsmith on Saturday November 05, 2022 @06:03PM (#33486356)

Missing a fun one: ctid

[ Parent | on HN ]

Re:Postgres Insider Terminology by pramsey on Saturday November 05, 2022 @06:50PM (#33486768)

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

[ Parent | on HN ]

Re:Postgres Insider Terminology by hot_gril on Saturday November 05, 2022 @09:15PM (#33487720)

pg_stat_activity

[ Parent | on HN ]

Re:Postgres Insider Terminology by asah on Saturday November 05, 2022 @06:53PM (#33486792)

ctid gives me ptsd !

[ Parent | on HN ]

Re:Postgres Insider Terminology by ryandotsmith on Saturday November 05, 2022 @07:55PM (#33487222)

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

[ Parent | on HN ]

Re:Postgres Insider Terminology by hot_gril on Saturday November 05, 2022 @09:17PM (#33487739)

Ohh. I always used row_number for that.

[ Parent | on HN ]