What to vacuum after deleting lots of tables
This is a discussion on What to vacuum after deleting lots of tables within the Pgsql Performance forums, part of the PostgreSQL category; --> If I delete a whole bunch of tables (like 10,000 tables), should I vacuum system tables, and if so, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 11:31 AM
| ||||
| ||||
 What to vacuum after deleting lots of tables If I delete a whole bunch of tables (like 10,000 tables), should I vacuum system tables, and if so, which ones? (This system is still on 8.1.4 and isn't running autovacuum). Thanks, Craig ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
|
04-19-2008, 11:31 AM
| ||||
| ||||
| Re: What to vacuum after deleting lots of tables Craig James <craig_james@emolecules.com> writes: > If I delete a whole bunch of tables (like 10,000 tables), should I vacuum system tables, and if so, which ones? (This system is still on 8.1.4 and isn't running autovacuum). "All of them" would do for a first approximation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
Linear Mode
