Heikki Linnakangas wrote:
Gábor Farkas wrote:
- but in the past, the cron-job was not in place, so the table's size
grew to around 800000 entries (in around 80 days)
That bloated your table, so that there's still a lot of empty pages in
it. VACUUM FULL should bring it back to a reasonable size. Regular
normal non-FULL VACUUMs should keep it in shape after that.
hmm... can a full-vacuum be performed while the database is still "live"
(i mean serving requests)?
will the db still be able to respond to queries?
or in a different way:
if i do a full vacuum to that table only, will the database still serve
data from the other tables at a normal speed?
thanks,
gabor
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
