Partitions and prepared statements? - Mailing list pgsql-performance

From Dave Johansen
Subject Partitions and prepared statements?
Date
Msg-id CAAcYxUfdcCKWw1+hA_gV3OUgZggBqpv1O4YER8Wa--_1DXt4wQ@mail.gmail.com
Whole thread Raw
List pgsql-performance
I'm working with a large database using 8.4 that's partitioned on 4 week boundaries and when I use a prepared statement that limits by time as one of the bind parameters the planner seems to not select just the partitions of interest but wants to scan all of them. From reading the documentation of 9.3 ( http://www.postgresql.org/docs/9.3/static/sql-prepare.html ), it seems that this sort of limitation has been fixed. Is that a correct interpretation of the documentation?
Thanks,
Dave

pgsql-performance by date:

Previous
From: "Gudmundsson Martin (mg)"
Date:
Subject: Re: Stalls on PGSemaphoreLock
Next
From: Jeff Janes
Date:
Subject: Re: Connection pooling - Number of connections