Re: constraint_exclusion on OLTP tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Chris Hoover <revoohc(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: constraint_exclusion on OLTP tables
Date: 2006-02-13 15:02:05
Message-ID: 28632.1139842925@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Chris Hoover <revoohc(at)gmail(dot)com> writes:
> The problem I am having is how can you safely move records between
> main_table_live and one of the other partition tables?

My advice is "don't do that". Partition just based on the year.
You can exploit your knowledge about status distribution by creating
suitable indexes.

> Also, is there a way to make foreign keys work with the partitioned table

No, not at present, which is another reason you don't want records
moving around.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Burrows 2006-02-13 15:59:38 Lost tables in Postgres 7.1
Previous Message Chris Browne 2006-02-13 14:59:33 Re: How to VACUUM this table? "998994633 estimated total rows"