Re: Good configuration? - Mailing list pgsql-general

From Tom Lane
Subject Re: Good configuration?
Date
Msg-id 28413.1006237379@sss.pgh.pa.us
Whole thread Raw
In response to Good configuration?  (sir_anodos@yahoo.com (anodos))
Responses Re: Good configuration?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-general
sir_anodos@yahoo.com (anodos) writes:
> shared_buffers = 96000

800MB of shared buffers in a 1GB machine is almost certainly
a *bad* idea.  I don't believe there is any good reason for going
over about a quarter of physical RAM, and one can make a pretty
strong argument that a few thousand shared buffers are enough
no matter how much RAM you have.  Leave it to the kernel to use
the rest of RAM.  Cf. my comments to mlw today in pgsql-hackers.

> deadlock_timeout = 5000

Do you have any reason for messing with deadlock_timeout?

            regards, tom lane

pgsql-general by date:

Previous
From: Mike Castle
Date:
Subject: email time warps
Next
From: Tatsuo Ishii
Date:
Subject: Re: Good configuration?