Re: Postgres on RAID5 - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Postgres on RAID5
Date
Msg-id 20050311223646.GA18059@dcc.uchile.cl
Whole thread Raw
In response to Re: Postgres on RAID5  (Arshavir Grigorian <ag@m-cam.com>)
List pgsql-performance
On Fri, Mar 11, 2005 at 05:29:11PM -0500, Arshavir Grigorian wrote:
> Tom Lane wrote:

> >The defaults are made for a fairly small machine, not big iron.  At a
> >minimum you want to kick shared_buffers up to 10K or more.
> >
> Will do. Thanks.

Also, it may help that you bump up sort_mem while doing [the CREATE
INDEX part of] the restore.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

pgsql-performance by date:

Previous
From: Arshavir Grigorian
Date:
Subject: Re: Postgres on RAID5
Next
From: Tom Lane
Date:
Subject: Re: Postgres on RAID5