currently we are testing postgres vs DB2 on speed and scalability. our test
database is approx 30GB and we are running freeBSD 4.3-STABLE with a 733MHZ
processor and 1GB of ram with postgres 7.1.2. our postgres queries are
taking over 4min while our DB2 queries are taking less than 30 sec. this is
really bad considering our DB will grow to over 6TB for 1 year worth of
data. Can postgres handle this, and is there a way to optimize the
postmaster to use all the system resources that it needs. currently we
start the postmaster this way:
pg_ctl -o "-o -F -B 3000 -N 2 -ps -pn" start
any help would be great.
thanks
andy
--
Andy Jenks
Compete Inc.
andy@compete.com