On Wed, Jun 15, 2005 at 02:06:27 -0700,
Todd Landfried <tlandfried(at)viatornetworks(dot)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.