Alvaro Herrera writes:
> On 2019-Apr-30, Tom Lane wrote:
>> regression=# explain select * from p1 where a = 3;
> But you're reading from the partition, not from the partitioned table ...
Argh! Where's my brown paper bag?
regards, tom lane
On 2019-Apr-30, Tom Lane wrote:
> regression=# explain select * from p1 where a = 3;
But you're reading from the partition, not from the partitioned table ...
--
Álvaro Herrerahttps://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
I'd have thought that disabling enable_partition_pruning would,
um, disable partition pruning. It does not:
regression=# create table p (a int) partition by list (a);
CREATE TABLE
regression=# create table p1 partition of p for values in (1);
CREATE TABLE
regression=# create table p2 partition of