David Kerr <dmk@xxxxxxxxxxxxxx> writes: > On Tue, Aug 03, 2010 at 03:49:57PM -0400, Tom Lane wrote: > - In recent versions of PG, no. Before about 8.3 it was a Really Bad Idea, > - because the open transaction would prevent VACUUM from reclaiming storage. > We're on 8.3.9, so hopefully it's fairly safe then? Should be. You might want to test it just to make sure I'm recalling correctly when that got fixed. Do a BEGIN in one session, then in another session insert and delete some rows in a table, then VACUUM VERBOSE and see if they get cleaned up. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
