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.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to