Re: PostgreSQL 8.4 performance tuning questions - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: PostgreSQL 8.4 performance tuning questions
Date
Msg-id alpine.DEB.2.00.0907301755150.19493@aragorn.flymine.org
Whole thread Raw
In response to Re: PostgreSQL 8.4 performance tuning questions  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: PostgreSQL 8.4 performance tuning questions
List pgsql-performance
On Thu, 30 Jul 2009, Kevin Grittner wrote:
> Steve Crawford <scrawford@pinpointresearch.com> wrote:
>> benchmarks I've seen suggest that with 8 cores you may even see an
>> almost 8x restore speedup
>
> I'm curious what sort of data in what environment showed that ratio.

It depends on a lot of things. However, certainly for index creation,
tests on servers over here have indicated that running four "CREATE INDEX"
statements at the time runs four times as fast, assuming the table fits in
maintenance_work_mem.

Matthew

--
 I have an inferiority complex. But it's not a very good one.

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: PostgreSQL 8.4 performance tuning questions
Next
From: "Kevin Grittner"
Date:
Subject: Re: PostgreSQL 8.4 performance tuning questions