Re: [PERFORM] Explains of queries to partitioned tables

2010-07-30 Thread Robert Haas
On Mon, Jul 26, 2010 at 4:47 AM, Vlad Arkhipov wrote: > There is a partitioned table with 2 partitions: > > drop table if exists p cascade; > > create table p ( >  id bigint not null primary key, >  ts timestamp); > > create table p_actual ( check (ts is null) ) inherits (p); > create table p_hist

[PERFORM] Explains of queries to partitioned tables

2010-07-26 Thread Vlad Arkhipov
There is a partitioned table with 2 partitions: drop table if exists p cascade; create table p ( id bigint not null primary key, ts timestamp); create table p_actual ( check (ts is null) ) inherits (p); create table p_historical ( check (ts is not null) ) inherits (p); -- I skipped the tri