ideas on optimization 
Author Message
 ideas on optimization

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.
Andy Jenks
Compete Inc.

Mon, 24 Nov 2003 01:52:52 GMT
 [ 1 post ] 

 Relevant Pages 

1. ideas on optimization

2. An optimization improvement idea

3. query optimization using substring function

4. Optimization drop after Service Pack 4- please, help!!!

5. searching MEMO fields - optimization question

6. Usage Based Optimization

7. Query optimization with federated databases

8. Star schema optimization

9. SPROCS and optimization

10. Usage Based Optimization error

11. Indexing/Optimization question

12. SQL Statement Optimization

Powered by phpBB® Forum Software