Yes, system tables are just tables. And every time to create/drop a temporary ta... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

btilly on Jan 27, 2021 | parent | context | favorite | on: Postgres scaling advice

Yes, system tables are just tables. And every time to create/drop a temporary table you've inserted/deleted a bunch of data from https://www.postgresql.org/docs/12/catalog-pg-attribute.html. If you do so faster than it can vacuum, you're in for a world of hurt.

mulmen on Jan 27, 2021 [–]

Huh. For a long time there was no autovacuum in Redshift and AFAIK this was never a problem for us. I wrote our VACUUM script and it would never pick up system tables. Maybe Redshift does something differently.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact