Hi, On 10 January 2012 06:10, Jason Buberel <[email protected]> wrote: > "Select median price for every zip code as of 2012-01-06" (customer exports) > "Select median price for 94086 from 2005-01-01 through 2012-01-06" (charting > apps) > > So by partitioning in one dimension we impact queries in the other.
I do not see any issue here; if all your queries contain date range then you should partition by date. -- Ondrej Ivanic ([email protected]) -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
