[GENERAL] Postgres performance problems.

Hi, We have developed an application using PG 6.5.1, DBI-1.13 and DBD-0.92 with perl5. We have a small db with a query with 5 joins and other smaller singleton selects. Now this query will be executed about 50 times a second. While doing a load test to find performance we find that for 100 para

[GENERAL] Release LRU file

Hi, This is in continuation of mails I sent last week about postgres crashing We are running pg 6.5.1, on Redhar 5.1 with DBI 0.92 and DBD 1.13 on a 512 MB RAM and SCSI machine Our application consists of requests going upto 150 per second on this database with an expected uptime of 24 by 7. Ear