Re: getting better 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