From: Eugeny N Dzhurinsky <bofh@redwerk.com>
To: pgsql-performance@postgresql.org
Subject: Re: getting better performance
Date: Thu, 6 Jul 2006 18:11:26 +0300
Message-ID: <20060706151126.GA9239@office.redwerk.com> (raw)
In-Reply-To: <1152196118.13851.110.camel@state.g2switchworks.com>
References: <20060706064016.GC1091@office.redwerk.com>
<1152196118.13851.110.camel@state.g2switchworks.com>
On Thu, Jul 06, 2006 at 09:28:39AM -0500, Scott Marlowe wrote:
> On Thu, 2006-07-06 at 01:40, Eugeny N Dzhurinsky wrote:
> Do you add / remove tables a lot? Could be you've got system catalog
> bloat.
Yes, almost each table is dropped and re-created in 3-5 days.
> do you have autovacuum running?
Yes.
> What version of pgsql are you running?
psql -V
psql (PostgreSQL) 8.0.0
> What OS?
CentOS release 3.7 (Final)
> What file system?
ext3
> What kind of machine are you using?
Pentium IV, 1.8 GHz
> How much memory does it have?
512 Mb RAM
> How many disk drives?
single
> Are you using RAID? hardware / software? battery backed cache or no?
no
> Do you have one or two, or thousands of connections at a time?
something like 20 connections (peak).
> Do you use connection pooling if you have lots of connections to handle?
My application uses Jakarta Commons DBCP module.
--
Eugene Dzhurinsky
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: bofh@redwerk.com
Subject: Re: getting better performance
In-Reply-To: <20060706151126.GA9239@office.redwerk.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