Partitioning

From: Abu Mushayeed <abumushayeed(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Partitioning
Date: 2007-01-30 06:42:20
Message-ID: 106956.78868.qm@web57108.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have partitioned a table based on period (e.g., cdate >= '2007-01-01'::date and cdate<=.2007-03-31':;date).

Now, I am issuing query like cdate >= CURRENT_DATE - 1 and cdate <= CURRENT_DATE, it scans all the partitions. But if I do cdate >= '2007-01-01'::date and cdate<=.2007-03-31'::date it picks the correct partition. Also if I join the cdate field with another table, it does not pick the correct partition.

I would like to know if it is possible to pick the correct partition using the above example.

Thanks
Abu


---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2007-01-30 07:10:14 Re: Partitioning
Previous Message Saranya Sivakumar 2007-01-29 20:51:17 Thanks All!