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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
