Re: 8.3 / 8.2.6 restore comparison - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 5641.1203701997@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: 8.3 / 8.2.6 restore comparison  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-hackers
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Yeah, that... is beyond my abilities. Well reading it is anyway. I can
> provide any information people want though. Tom? Greg? Andrew? Somebody?
> What information do you want from me to help you track this down?

The vmstat output you showed before said user CPU time was only around
12%, which seems to destroy Luke's thesis that data conversion time
is the problem.  IIRC we were speculating that data was being written
in a pattern that required a lot of seeking thus ruining throughput,
but we didn't have any hard evidence of that.  Did you do the strace'ing
I suggested?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Including PL/PgSQL by default
Next
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison