From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Need help in reclaiming disk space by deleting the selected records |
Date: | 2012-09-28 08:08:06 |
Message-ID: | 50655AE6.4000704@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/28/12 12:36 AM, Albe Laurenz wrote:
> Yelai, Ramkumar wrote:
> >7 base tables X 120 months = 840 child tables. As per your statement, If I create these many table then it will affect the performance. But as per the document (http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html) constraint_exclusion will improve query performance. Please clarify me here how query planning will be expensive?
> The planner will have to decide which of the 840 tables
> to access.
>
well, really, which of the 120 tables for a given base table. he's got
7 different base tables. 120 partitions is still too many.
if I was partioning a table for 2 year retention, I'd probably do it by
month, or even quarter, so there would be 24 or 8 child tables for 2
years. we use week tables for 6 months, but almost all of our
activity is to the latest week and the one before that, its quite rare
we need to dig back to older records..
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
From | Date | Subject | |
---|---|---|---|
Next Message | Carrington, Matthew (Produban) | 2012-09-28 10:14:58 | Re: pg_upgrade: out of memory |
Previous Message | Albe Laurenz | 2012-09-28 07:36:46 | Re: Re: Need help in reclaiming disk space by deleting the selected records |