| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: vac truncation scan problems |
| Date: | 2015-04-01 01:49:55 |
| Message-ID: | CAB7nPqTMBd6=5i3ZOg9t6A0km4VZ=wNt4_rwOzPVm683-aQ=Qw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Apr 1, 2015 at 2:18 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> On Tue, Mar 31, 2015 at 1:28 AM, Kyotaro HORIGUCHI <
> horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote:
>
>> Hi, this is a bug in the commit 0d831389749a3baaced7b984205b9894a82444b9 .
>>
>> It allows vucuum freeze to be skipped and inversely lets regular
>> vacuum wait for lock. The attched patch fixes it.
>>
>>
>> In table_recheck_autovac, vacuum options are determined as following,
>>
>> > tab->at_vacoptions = VACOPT_SKIPTOAST |
>> > (dovacuum ? VACOPT_VACUUM : 0) |
>> > (doanalyze ? VACOPT_ANALYZE : 0) |
>> !> (wraparound ? VACOPT_NOWAIT : 0);
>>
>> The line prefixed by '!' looks inverted.
>>
>
> Thanks, it is obvious once you see it!
>
Nice catch, Horiguchi-san.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2015-04-01 03:01:28 | pg_restore -t should match views, matviews, and foreign tables |
| Previous Message | Peter Eisentraut | 2015-04-01 01:48:39 | Re: libpq's multi-threaded SSL callback handling is busted |