Re: getting better performance

From: Eugeny N Dzhurinsky <bofh(at)redwerk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: getting better performance
Date: 2006-07-06 15:11:26
Message-ID: 20060706151126.GA9239@office.redwerk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2006-07-06 15:26:54 Re: getting better performance
Previous Message Merlin Moncure 2006-07-06 14:44:26 Re: Opteron/FreeBSD/PostgreSQL performance poor