From: Gregory Stewart <gstewart512@gmail.com>
To: pgsql-performance@postgresql.org
Subject: PostgreSQL not fully utilizing system resources?
Date: Fri, 1 Jun 2007 14:40:19 -0500
Message-ID: <d9731dbe0706011240o11214bc4s92d0785ac35f66a@mail.gmail.com> (raw)
Hello List,
We've been running PostgreSQL as our web application database for
almost a year and it has noticeably slowed down over last few months.
Our current setup and pgsql configuration looks like this:
8.1.2 on Ubuntu 4 on Opteron Dual Core with 2 GBytes RAM. This is a
dedicated DB server.
We currently have about 3.5 million rows in 91 tables. Besides the
requests coming from the web server, we have batch processes running
every 15 minutes from another internal machine that do a lot of
UPDATE, DELETE and INSERT queries on thousands of rows.
Many of the SELECT queries coming from the web server contain large
JOINS and aggregate calculations.
We are running a financial application which is very data intensive
and calculates a lot on the SQL side.
Anyways, watching the system processes we realized that PostgreSQL is
only using about 300 Mbytes for itself. Also, both cores are usually
maxed out to 100% usage.
Are we expecting too much from our server?
Our non-default configuration settings are:
max_connections = 100
shared_buffers = 17500
work_mem = 2048
maintenance_work_mem = 40000
max_fsm_pages = 35000
autovacuum = on
What can I do to make best use of my db server? Is our configuration
flawed? Or are we already at a point where we need consider clustering
/ load balancing?
Any ideas and suggestions are welcome.
Regards,
Gregory Stewart
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: gstewart512@gmail.com
Subject: Re: PostgreSQL not fully utilizing system resources?
In-Reply-To: <d9731dbe0706011240o11214bc4s92d0785ac35f66a@mail.gmail.com>
* 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