Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Tomas VondraDate: 2007-01-30 07:10:14
Subject: Re: Partitioning
Previous:From: Saranya SivakumarDate: 2007-01-29 20:51:17
Subject: Thanks All!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group