Skip site navigation (1) Skip section navigation (2)

Re: COPY and partitioning

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: Colton A Smith <smith(at)cs(dot)utk(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: COPY and partitioning
Date: 2005-11-19 00:29:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Thinking about dumping the schema, rewriting that structure with your
partitioning needs, and after copy the data.
 Why not?
 Just 2 cents, never done it.
 to dump a schema:
pg_dump -s dbname > dbname.schema
 Then just restore the data, it should work I guess.
 Best regards,

 On 11/17/05, Colton A Smith <smith(at)cs(dot)utk(dot)edu> wrote:
> 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

"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

In response to

pgsql-admin by date

Next:From: vinod.sadanandanDate: 2005-11-19 11:06:04
Subject: Batch Files
Previous:From: John JensenDate: 2005-11-19 00:15:46
Subject: Re: Server Hardware Configuration

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group