Postgres Pro
Downloads
Home   >   mailing lists

BUG #3714: applications using COPY are now much slower - Mailing list pgsql-bugs

From Radim Kolar
Subject BUG #3714: applications using COPY are now much slower
Date
Msg-id 200711021808.lA2I8QJP098286@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3714: applications using COPY are now much slower
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3714
Logged by:          Radim Kolar
Email address:      kolar.radim@gmail.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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: I have a question about using index in order statement.
Next
From: Tom Lane
Date:
Subject: Re: tsvector that can't be dumped/reloaded in 8.3beta