On 26-Nov-06, at 8:11 AM, Steinar H. Gunderson wrote:
On Sun, Nov 26, 2006 at 09:43:11AM -0300, Marcelo Costa wrote:
All its tables constantly manipulated (INSERT, UPDATE, DELETE)
they need a
VACUUM
Just a minor clarification here: INSERT does not create dead rows,
only
UPDATE and DELETE do. Thus, if you only insert rows, you do not
need to
vacuum (although you probably need to analyze).
Not entirely true. An insert & rollback will create dead rows. If you
attempt and fail a large number of insert transactions then you will
still need to vacuum.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
