COPY and partitioning - Mailing list pgsql-admin

From Colton A Smith
Subject COPY and partitioning
Date
Msg-id Pine.LNX.4.62.0511170946370.29277@cetus5.cs.utk.edu
Whole thread Raw
Responses Re: COPY and partitioning  (Guido Barosio <gbarosio@gmail.com>)
Re: COPY and partitioning  (Simon Riggs <simon@2ndquadrant.com>)
List 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.

pgsql-admin by date:

Previous
From: Wim Bertels
Date:
Subject: Re: md5 collision generator
Next
From: Colton A Smith
Date:
Subject: fsm allocation