Re: Needed: Simplified guide to optimal memory configuration - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: Needed: Simplified guide to optimal memory configuration
Date
Msg-id 20050615141949.GB7595@wolff.to
Whole thread Raw
In response to Needed: Simplified guide to optimal memory configuration  (Todd Landfried <tlandfried@viatornetworks.com>)
List pgsql-performance
On Wed, Jun 15, 2005 at 02:06:27 -0700,
  Todd Landfried <tlandfried@viatornetworks.com> wrote:
>
> What's the problem? The sucker gets s-l-o-w on relatively simple
> queries. For example, simply listing all of the users online at one
> time takes 30-45 seconds if we're talking about 800 users. We've
> adjusted the time period for vacuuming the tables to the point where
> it occurs once an hour, but we're getting only a 25% performance gain
> from that. We're looking at the system settings now to see how those
> can be tweaked.

It might be useful to see example slow queries and the corresponding
explain analyze output.

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Needed: Simplified guide to optimal memory configuration
Next
From: Karim Nassar
Date:
Subject: Re: Index ot being used