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.