Thread: BUG #3714: applications using COPY are now much slower
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.
"Radim Kolar" <kolar.radim@gmail.com> writes: > Applications using COPY for batch insert few records are now much slower on > heavily updated table than in 8.2. Please give a *specific* test case showing what you are talking about... > I recommend to add some configuration file switch for switching COPY between > old and new mode or add COPY NOLOG keyword. ... because this suggestion makes no sense whatsoever. There is no "old and new mode". regards, tom lane