Re: how much ram do i give postgres?

From: Josh Close <narshe(at)gmail(dot)com>
To: POSTGRES <pgsql-general(at)postgresql(dot)org>
Subject: Re: how much ram do i give postgres?
Date: 2004-10-19 22:35:14
Message-ID: 4a0cafe2041019153557b65563@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 19 Oct 2004 17:42:16 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pw 2004-10-19 22:49:04 Re: How do I recover from>> pg_xlog/0000000000000000 (log
Previous Message Steven Klassen 2004-10-19 22:18:46 Re: reusing column labels in select