From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
---|---|
To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
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:42:23 |
Message-ID: | CAKJS1f_yjtHDJnDzx1uuR_3D7beDVAkNQfWJhRLA1gvPCzkAhg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On 8 April 2018 at 15:34, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> wrote:
> You can't ever assume that data you just inserted will become
> all-visible just because you just vacuumed the table, unless you know
> that there is NO concurrent activity that might have a snapshot (and no
> other possible reason why OldestXmin might be older than your insert).
Thanks. I got it. It just slipped my slightly paranoid and sleep deprived mind.
I've attached my proposed fix for the unstable regression tests. I
removed the vacuums I'd added in the last version and commented why
we're doing set enable_indesonlyscan = off;
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Attachment | Content-Type | Size |
---|---|---|
runtime_pruning_make_tests_stable_v2.patch | application/octet-stream | 29.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2018-04-08 05:09:52 | pgsql: Support index INCLUDE in the AM properties interface. |
Previous Message | Andrew Gierth | 2018-04-08 03:34:22 | Re: pgsql: Support partition pruning at execution time |
From | Date | Subject | |
---|---|---|---|
Next Message | Christophe Pettus | 2018-04-08 03:46:17 | Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS |
Previous Message | Peter Geoghegan | 2018-04-08 03:37:06 | Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS |