The actual data returned is a tiny fraction of the total table volume. Is there a way to force an index scan on the partitions in a guaranteed manner without resorting to re-writing queries with the union all on partitions.
Thank you Sriram On Wed, Oct 14, 2009 at 10:15 PM, Tom Lane <[email protected]> wrote: > Anj Adu <[email protected]> writes: >> This query is doing a sequential scan on the child partitions even >> though indexes on all constrained columns are present > > It looks to me like it's doing exactly what it is supposed to, ie, > indexscan on the partitions where it would help and seqscans on the > partitions where it wouldn't. Indexscan is not better than seqscan > for retrieving all or most of a table. > > regards, tom lane > -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
