Re: how much mem to give postgres?

From: Josh Close <narshe(at)gmail(dot)com>
To: POSTGRES-PERFORMANCE <pgsql-performance(at)postgresql(dot)org>
Subject: Re: how much mem to give postgres?
Date: 2004-10-20 13:39:53
Message-ID: 4a0cafe204102006391f726a4f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 19 Oct 2004 22:23:24 -0700, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> There have been issues with Postgres+HT, especially on Linux 2.4. Try
> turning HT off if other tuning doesn't solve things.
>
> Otherwise, see:
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

How would I turn that off? In the kernel config? Not too familiar with
that. I have a 2 proc xeon with 4 gigs of mem on the way for postgres,
so I hope HT isn't a problem. If HT is turned off, does it just not
use the other "half" of the processor? Or does the processor just work
as one unit?

Also, I'm taking a look at that site right now :)

-Josh

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Clark 2004-10-20 14:07:00 Re: how much mem to give postgres?
Previous Message Josh Close 2004-10-20 13:36:49 Re: how much mem to give postgres?