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

From Jeff Davis
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 1203977158.7878.59.camel@dogma.ljc.laika.com
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>)
List pgsql-hackers
On Mon, 2008-02-25 at 12:28 -0800, Joshua D. Drake wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> On Mon, 25 Feb 2008 12:17:10 -0800
> Jeff Davis <pgsql@j-davis.com> wrote:
> 
> 
> > > I would personally rather keep it simple, hard core, and data
> > > shoving as possible without any issue with scheduling etc..
> > > 
> > 
> > Just a thought. After it's actually implemented it won't be hard to
> > see if it's a win.
> 
> Yep :) but as a note:
> 
> I am currently testing on the data set that is giving us all these
> issues. Previously we were pushing ~ 22G an hour over a single thread.
> I am currently pushing ~ 28G every 16 minutes over 6 threads.
> 
> With 30-40% IO wait.

That begs the question: what about 12 threads?

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: libpq.rc make rule
Next
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison