Re: memory tuning

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: memory tuning
Date: 2006-06-21 10:37:30
Message-ID: C0BE99AA.D1F8%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 6/20/06 9:33 PM, "Tom Allison" <tallison(at)tacocat(dot)net> wrote:

> But I'm not utilizing much memory and things are running frighteningly slow.
> I did run a VACUUM ANALYZE today with no incidents so I wouldn't expect that
> to
> be a problem. I don't think there have been more than 10^5 transactions since
> then (assuming that's not too many?)
>
> tips?

What is slow about the database? Do you have particular queries that are
slow? Have you looked at EXPLAIN output? What is the table structure?

Yes, memory settings can speed up a database (I'm no expert in the settings
arena, so I won't answer that directly), but there are often other issues
that impact performance that are at least as important.

Sean

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Christo Romberg 2006-06-21 14:51:55 Documents Database - HELP
Previous Message Tom Allison 2006-06-21 01:33:12 memory tuning