Re: Postgres on RAID5

From: Alvaro Herrera
Subject: Re: Postgres on RAID5
Date: ,
Msg-id: 20050311223646.GA18059@dcc.uchile.cl
(view: Whole thread, Raw)
In response to: Re: Postgres on RAID5  (Arshavir Grigorian)
List: pgsql-performance

Tree view

Postgres on RAID5  (Arshavir Grigorian, )
 Re: Postgres on RAID5  (Tom Lane, )
  Re: Postgres on RAID5  (Arshavir Grigorian, )
   Re: Postgres on RAID5  (Alvaro Herrera, )
   Re: Postgres on RAID5  (Tom Lane, )
 Re: Postgres on RAID5  (Arshavir Grigorian, )
  Re: Postgres on RAID5  (PFC, )
 Re: Postgres on RAID5  (Josh Berkus, )
  Re: Postgres on RAID5  (Arshavir Grigorian, )
 Re: Postgres on RAID5  (Alex Turner, )
  Re: Postgres on RAID5  ("Joshua D. Drake", )
  Re: Postgres on RAID5  (Arshavir Grigorian, )
   Re: Postgres on RAID5  (Alex Turner, )
 Re: Postgres on RAID5  ("Alexander Kirpa", )

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:

From: "Joshua D. Drake"
Date:
Subject: Re: Postgres on RAID5
From: "Tambet Matiisen"
Date:
Subject: One tuple per transaction