From: Jacques Caron <jc@directinfos.com>
To: Patrick Hatcher <PHatcher@macys.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Sluggish server performance
Date: Mon, 28 Mar 2005 20:39:21 +0200
Message-ID: <6.2.0.14.0.20050328203405.052aa7c0@pop.interactivemediafactory.net> (raw)
In-Reply-To: <OFCA5F4B6E.961A6875-ON88256FD2.0062D121-88256FD2.0065040E@ fds.com>
References: <OFCA5F4B6E.961A6875-ON88256FD2.0062D121-88256FD2.0065040E@fds.com>
Hi,
At 20:20 28/03/2005, Patrick Hatcher wrote:
>I'm experiencing extreme load issues on my machine anytime I have more than
>40 users connected to the database. The majority of the users appear to be
>in an idle state according TOP, but if more than3 or more queries are ran
>the system slows to a crawl. The queries don't appear to the root cause
>because they run fine when the load drops. I also doing routine vacuuming
>on the tables.
>
>Is there some place I need to start looking for the issues bogging down the
>server?
Check that your queries use optimal plans, which usually (but not always)
means they should use indexes rather than sequential scans. You can check
for this by using EXPLAIN <query> or EXPLAIN ANALYZE <query>. You can also
check the pg_stat_* and pg_statio_* tables to get a feel of what kind of
accesses are done. You also might want to find out if your system is
limited by IO or by the CPU. Most probably the former.
You can also check the "performance tips" section of the manual.
Also you shared_buffers setting seems to be pretty low given your
configuration.
Hope that helps,
Jacques.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jc@directinfos.com, PHatcher@macys.com
Subject: Re: Sluggish server performance
In-Reply-To: <6.2.0.14.0.20050328203405.052aa7c0@pop.interactivemediafactory.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox