Postgres Pro
Downloads
Home   >   mailing lists

Re: how much ram do i give postgres? - Mailing list pgsql-general

From Josh Close
Subject Re: how much ram do i give postgres?
Date
Msg-id 4a0cafe2041019153557b65563@mail.gmail.com
Whole thread Raw
In response to Re: how much ram do i give postgres?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: how much ram do i give postgres?  ("Gary Doades" <gpd@gpdnet.co.uk>)
List pgsql-general
Tree view 
On Tue, 19 Oct 2004 17:42:16 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The short answer is no; the sweet spot for shared_buffers is usually on
> the order of 10000 buffers, and trying to go for "75% of RAM" isn't
> going to do anything except hurt.  For the long answer see the
> pgsql-performance list archives.
>
>                         regards, tom lane

Well, I didn't find a whole lot in the list-archives, so I emailed
that list whith a few more questions. My postgres server is just
crawling right now :(

-Josh

pgsql-general by date:

Previous
From: Steven Klassen
Date:
Subject: Re: reusing column labels in select
Next
From: pw
Date:
Subject: Re: How do I recover from>> pg_xlog/0000000000000000 (log