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 arhi...@dc.baikal.ru 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

[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