PostgreSQL performance tuning

Hi, all

I have a postgresql 7.4 running on mandriva linux 10.1 with 512M RAM & AMD
2000+ CPU. I increased system share memory to 128M, buffer to 64M, sort memory
to 32M. A single query do finish much faster. Now I need to analyze some weekly
data involving hundred queries with 'group by order by' operation. Total data
less than 250M, but did take some time to complete. How can I tune my system to
handle a lot of concurrent quries at the same time and do it faster?

BTW, upgrade hardware is not an option at this time. ;>

Thanks,

Vincent Chen

___________________________________________________ 最新版 Yahoo!奇摩即時通訊 7.0，免費網路電話任你打！ http://messenger.yahoo.com.tw/