Re: BUG #3714: applications using COPY are now much slower

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Radim Kolar" <kolar(dot)radim(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3714: applications using COPY are now much slower
Date: 2007-11-02 19:25:16
Message-ID: 22203.1194031516@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Radim Kolar" <kolar(dot)radim(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Haegi 2007-11-02 19:46:56 BUG #3715: StackBuilder failing
Previous Message Tom Lane 2007-11-02 19:16:21 Re: BUG #3713: problem with thread safety???