Your point solved my problem.
Thank you
-Fayza
On 12/4/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Fayza Sultan" <[EMAIL PROTECTED]> writes:
> CREATE TABLE parent (
> monthdate date NOT NULL,
> id int4 NOT NULL,
> CONSTRAINT parent_idx PRIMARY
I am trying to optimize queries on one of the large table we have by
partitioning it. To test it I created a sample script. When I use Explain
Analyze on one of the queries the query planer shows sequence scan on all
the child partitions instead of only one child containing the required data.
I am
