| From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Error correction for n_dead_tuples |
| Date: | 2007-02-02 02:47:54 |
| Message-ID: | 20070202113602.59FF.ITAGAKI.TAKAHIRO@oss.ntt.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| n_dead_tuples.patch | application/octet-stream | 5.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Drake | 2007-02-02 03:29:35 | Re: [HACKERS] writing new regexp functions |
| Previous Message | Koichi Suzuki | 2007-02-02 02:05:52 | Re: [HACKERS] Full page writes improvement |