Re: Time to move table to new tablespace - Mailing list pgsql-general

From Ondrej Ivanič
Subject Re: Time to move table to new tablespace
Date
Msg-id CAM6mieKwhWfxE-20DNvURxCF=9Q3VhA38a=++FCXedmQJz=BPw@mail.gmail.com
Whole thread Raw
In response to Re: Time to move table to new tablespace  (Jason Buberel <jason@altosresearch.com>)
List pgsql-general
Hi,

On 10 January 2012 06:10, Jason Buberel <jason@altosresearch.com> 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
(ondrej.ivanic@gmail.com)

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: How do you change the size of the WAL files?
Next
From: Tom Lane
Date:
Subject: Re: How do you change the size of the WAL files?