Simon Riggs wrote:
On Fri, 2007-05-11 at 22:59 +0100, Heikki Linnakangas wrote:
For comparison, here's the test results with vanilla CVS HEAD:

  copy-head         | 00:06:21.533137
copy-head | 00:05:54.141285

I'm slightly worried that the results for COPY aren't anywhere near as
good as the SELECT and VACUUM results. It isn't clear from those numbers
that the benefit really is significant.

Agreed, the benefit isn't clear.

Are you thinking that having COPY avoid cache spoiling is a benefit just
of itself? Or do you see a pattern of benefit from your other runs?

I think it's worth having just to avoid cache spoiling. I wouldn't bother otherwise, but since we have the infrastructure for vacuum and large seqscans, we might as well use it for COPY as well.

(BTW what was wal_buffers set to? At least twice the ring buffer size,

Good question. [checks]. wal_buffers was set to 128KB. I tried raising it to 1MB, but it didn't make any difference.

  Heikki Linnakangas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to