Re: how much ram do i give postgres?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Josh Close <narshe(at)gmail(dot)com>
Cc: POSTGRES <pgsql-general(at)postgresql(dot)org>
Subject: Re: how much ram do i give postgres?
Date: 2004-10-20 18:35:43
Message-ID: 20041020183543.GA28409@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 20, 2004 at 08:25:22 -0500,
Josh Close <narshe(at)gmail(dot)com> wrote:
>
> It's slow due to several things happening all at once. There are a lot
> of inserts and updates happening. There is periodically a bulk insert
> of 500k - 1 mill rows happening. I'm doing a vacuum anaylyze every
> hour due to the amount of transactions happening, and a vacuum full
> every night. All this has caused selects to be very slow. At times, a
> "select count(1)" from a table will take several mins. I don't think
> selects would have to wait on locks by inserts/updates would it?

You might not need to do the vacuum fulls that often. If the your hourly
vacuums have a high enough fsm setting, they should be keeping the database
from continually growing in size. At that point daily vacuum fulls are
overkill and if they are slowing stuff down you want to run quickly, you
should cut back on them.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josh Close 2004-10-20 18:38:14 Re: how much ram do i give postgres?
Previous Message Dennis Gearon 2004-10-20 18:34:54 max length bit(x) bit varying(x)