Re: Postgres on RAID5

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Arshavir Grigorian <ag(at)m-cam(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres on RAID5
Date: 2005-03-11 22:36:46
Message-ID: 20050311223646.GA18059@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
"We are who we choose to be", sang the goldfinch
when the sun is high (Sandman)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-03-11 22:37:10 Re: Postgres on RAID5
Previous Message Arshavir Grigorian 2005-03-11 22:29:11 Re: Postgres on RAID5