Error correction for n_dead_tuples - Mailing list pgsql-patches

From ITAGAKI Takahiro
Subject Error correction for n_dead_tuples
Date
Msg-id 20070202113602.59FF.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
Responses Re: Error correction for n_dead_tuples  (Bruce Momjian <bruce@momjian.us>)
Re: Error correction for n_dead_tuples  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Koichi Suzuki
Date:
Subject: Re: [HACKERS] Full page writes improvement
Next
From: Jeremy Drake
Date:
Subject: Re: [HACKERS] writing new regexp functions