partition pruning

From: Anj Adu <fotographs(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: partition pruning
Date: 2010-03-01 19:29:26
Message-ID: f2fd819a1003011129h2222281fqa67bc45e051c6dd8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

When I use intervals in my query e.g col1 between current_timestamp -
interval '10 days' and current_timestamp...the optimizer checks ALL
partitions whereas if I use col1 between 2 hardcoded dates..only
the applicable partitions are scanned.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Yeb Havinga 2010-03-01 19:34:38 Re: Query slowing down significantly??
Previous Message Rainer Pruy 2010-03-01 18:49:07 Re: Query slowing down significantly??