Heikki Linnakangas wrote:
Gábor Farkas wrote:if i do a full vacuum to that table only, will the database still serve data from the other tables at a normal speed?Yes. The extra I/O load vacuum full generates while it's running might disrupt other activity, though.
i see.will i achieve the same thing by simply dropping that table and re-creating it?
gabor ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster