Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id 19295.1245364753@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: 8.4 open item: copy performance regression?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: 8.4 open item: copy performance regression?  (Alan Li <ali@truviso.com>)
List pgsql-hackers
Tree view 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote: 
>> I am unable to duplicate any slowdown on this test case.

> [ Kevin can ]

It'd be useful first off to figure out if it's a CPU or I/O issue.
Is there any visible difference in vmstat output?  Also, try turning
off autovacuum in both cases, just to see if that's related.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: 8.4 open item: copy performance regression?
Next
From: Greg Stark
Date:
Subject: Re: [PATCH] backend: compare word-at-a-time in bcTruelen