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


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: (view raw or whole 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.


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


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-2015 The PostgreSQL Global Development Group