BUG #3714: applications using COPY are now much slower

From: "Radim Kolar" <kolar(dot)radim(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3714: applications using COPY are now much slower
Date: 2007-11-02 18:08:26
Message-ID: 200711021808.lA2I8QJP098286@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3714
Logged by: Radim Kolar
Email address: kolar(dot)radim(at)gmail(dot)com
PostgreSQL version: 8.3 beta2
Operating system: BSD/64bit
Description: applications using COPY are now much slower
Details:

Applications using COPY for batch insert few records are now much slower on
heavily updated table than in 8.2.

Using COPY for importing database dumps in 8.3 is noticeable faster than in
8.2

I recommend to add some configuration file switch for switching COPY between
old and new mode or add COPY NOLOG keyword.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-11-02 18:25:37 Re: tsvector that can't be dumped/reloaded in 8.3beta
Previous Message Tom Lane 2007-11-02 17:34:27 Re: I have a question about using index in order statement.