Re: COPY slows down?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Harding <mvh(at)ix(dot)netcom(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: COPY slows down?
Date: 2004-10-11 14:22:03
Message-ID: 4972.1097504523@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mike Harding <mvh(at)ix(dot)netcom(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-10-11 14:26:08 Re: why my query is not using index??
Previous Message Tom Lane 2004-10-11 14:14:18 Re: Views, joins and LIMIT