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
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 |