Re: horizontal partition - Mailing list pgsql-performance

From Josh Berkus
Subject Re: horizontal partition
Date
Msg-id 200502021916.08960.josh@agliodbs.com
Whole thread Raw
In response to Re: horizontal partition  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: horizontal partition
List pgsql-performance
Gaetano,

> I did in that way just to not use postgresql specific feature.
> I can give it a try and I let you know, however the question remain,
> why the index usage is lost if used in that way ?

Because PostgreSQL is materializing the entire UNION data set in the
subselect.   What Postgres version are you using?   I thought this was fixed
in 7.4, but maybe not ...

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: horizontal partition
Next
From: Klint Gore
Date:
Subject: Re: horizontal partition