News for hackers. Stuff that matters.

A comment on Features I'd Like in PostgreSQL. Parent comment

Re:Features I'd Like in PostgreSQL by taffer on Saturday January 28, 2023 @05:07PM (#34562496)
Temp tables are per session, there shouldn't be any locking involved.
[ Parent | on HN ]
Re:Features I'd Like in PostgreSQL by zeroimpl on Saturday January 28, 2023 @06:47PM (#34563238)
I believe the metadata about them is still written to various system catalog tables. Creating lots of temp tables will cause autovacuum activity on tables like pg_attr, for example.
[ Parent | on HN ]