COPY and partitioning

From: Colton A Smith <smith(at)cs(dot)utk(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: COPY and partitioning
Date: 2005-11-17 14:55:44
Message-ID: Pine.LNX.4.62.0511170946370.29277@cetus5.cs.utk.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

I understand v8.1 implements table partitioning. Very exciting!

I have a big table (30 G) that is a real headache. I'd like to
partition it. My plan is the following: (1) use pg_dump -t to
dump the data; (2) create a partitioning schema with check constraints;
and (3) repopulate using the COPY utility.

My question: does the COPY utility consult check constraints
before populating tables?

Thanks as always.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message codeWarrior 2005-11-17 15:36:49 Re: restore challenge
Previous Message Michael D. Sofka 2005-11-17 14:54:38 Server Hardware Configuration