Re: 7.1.3 : copy from stdin is very slow!

I apologise for not giving details. I didn't know what details were necessary
to give. I now know.

As I found out, it was schema which was my downfall! Before my upgrade I dumped
the schema, dropped the database, and recreated the database, and imported the
schema back. I didn't remove a secondary index I had from 7.0.3. While it was
copying, it was updating the index, and taking forever to do it! Tom, thank you
for the kick in the right direction. (Note to self: Remove secondary indexes
when using "COPY ... FROM STDIN" unless being paid by the hour.)

Once removed, the table copy took less than three hours.

CG

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Chris Gamache <cgg007(at)yahoo(dot)com> writes:
> > I'm still at a loss for what could be going on.
>
> You still haven't given us any real details, like say the schema for the
> table being loaded. I'm wondering about triggers and foreign-key
> references, myself.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com