When to use Vacuum?
| От | Bill Thoen |
|---|---|
| Тема | When to use Vacuum? |
| Дата | |
| Msg-id | 4C2392FD.3000306@gisnet.com обсуждение исходный текст |
| Ответы |
Re: When to use Vacuum?
|
| Список | pgsql-general |
I'm putting some large read-only data sets together and occasionally I change my mind about something, drop a table or two and replace them with something different. Do I need to use VACUUM when I drop or re-arrange tables? Or does PG release disk space when you drop tables? And finally, if the tables are strictly read-only, then do I need to use VACUUM at all on a regular basis? (Like, do selections take up disk space that needs to be cleaned up on a regular basis? It's my understanding that VACUUM only clears or marks for re-use deleted records, but the docs say nothing about deleted tables and I don't want to get into an intolerable situation someday (like disk full.) TIA, - Bill Thoen
В списке pgsql-general по дате отправления: