Re: COPY slows down? - Mailing list pgsql-performance

From Tom Lane
Subject Re: COPY slows down?
Date
Msg-id 4972.1097504523@sss.pgh.pa.us
Whole thread Raw
In response to COPY slows down?  (Mike Harding <mvh@ix.netcom.com>)
List pgsql-performance
Mike Harding <mvh@ix.netcom.com> writes:
> I just ran a COPY of a million records several times, and each time I
> ran it it ran apparently exponentially slower.

Tell us about indexes, foreign keys involving this table, triggers, rules?

Some mention of your PG version would be appropriate, too.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Views, joins and LIMIT
Next
From: Tom Lane
Date:
Subject: Re: why my query is not using index??