Simon Riggs <simon@xxxxxxxxxxxxxxx> writes: > On Tue, 2008-04-01 at 10:22 -0400, Tom Lane wrote: >> In the fourth, if we actually believed this was a problem we'd >> need to redesign VACUUM too, as it does the same thing. > VACUUM waits until nobody else has the buffer pinned, so lock contention > is much less of a consideration there. Plus it rearranges the block, > which is hard to do one tuple at a time even if we wanted to. That's the second scan. The first scan acts exactly like Pavan is proposing for ANALYZE. 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
