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
