Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --------------------------------------------------------------------------- ITAGAKI Takahiro wrote: > Here is a patch discussed in > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00010.php > > Concurrent vacuum will save n_dead_tuples value at the beginning. > Stats collector will be subtract the value from n_dead_tuples > instead of setting it to zero. The statistics accuracy of n_dead_tuples > will be better, especially just after finish of a vacuum. > > The behavior in VACUUM FULL is not changed because concurrent updates > are not allowed during VACUUM FULL. > > Comments welcome. > > Regards, > --- > ITAGAKI Takahiro > NTT Open Source Software Center [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings