| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Cc: | Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: BUG #14057: vacuum setting reltuples=0 for tables with >0 tuples |
| Date: | 2017-03-16 06:55:54 |
| Message-ID: | 87y3w53est.fsf@news-spur.riddles.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
>>>>> "Andres" == Andres Freund <andres(at)anarazel(dot)de> writes:
>> It looks like fixing this requires breaking scanned_pages out into
>> at least two separate counters, since we currently use it to track
>> both whether we can update stats, and whether we can update
>> relfrozenxid.
Andres> Are you planning to submit a fix?
Somewhat belatedly, yes.
Attached are patches against master and all the back branches back to
9.2. I've reproduced the bug on all of them, and confirmed that this
fixes it on all of them. Is it worth also including the isolation
tester script in the changes?
I can go ahead and commit these if they look ok.
--
Andrew (irc:RhodiumToad)
| Attachment | Content-Type | Size |
|---|---|---|
| vacstats_92.patch | text/x-patch | 3.1 KB |
| vacstats_93.patch | text/x-patch | 3.1 KB |
| vacstats_94.patch | text/x-patch | 3.1 KB |
| vacstats_95.patch | text/x-patch | 3.1 KB |
| vacstats_96.patch | text/x-patch | 3.2 KB |
| vacstats_head.patch | text/x-patch | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2017-03-16 08:40:11 | Re: BUG #13755: pgwin32_is_service not checking if SECURITY_SERVICE_SID is disabled |
| Previous Message | John R Pierce | 2017-03-16 06:06:02 | Re: aspnet postgresql connection setting |