| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgsql: Support partition pruning at execution time |
| Date: | 2018-04-08 03:21:10 |
| Message-ID: | 87a7ueidzv.fsf@news-spur.riddles.org.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
>>>>> "David" == David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> writes:
>> It happens 12 or 13 times on my machine, then does not happen again
>> for 60 seconds, then happens again.
David> Setting autovacuum_naptime to 10 seconds makes it occur in 10
David> second intervals...
Analyze (including auto-analyze on a different table entirely) has a
snapshot, which can hold back OldestXmin, hence preventing the
all-visible flag from being set.
--
Andrew (irc:RhodiumToad)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-04-08 03:21:18 | Re: pgsql: Support partition pruning at execution time |
| Previous Message | Andrey Borodin | 2018-04-08 03:06:32 | Re: pgsql: Indexes with INCLUDE columns and their support in B-tree |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2018-04-08 03:21:18 | Re: pgsql: Support partition pruning at execution time |
| Previous Message | David Rowley | 2018-04-08 03:02:01 | Re: pgsql: Support partition pruning at execution time |