On Wed, Jun 15, 2005 at 02:06:27 -0700,
  Todd Landfried <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to