[GENERAL] Cannot Achieve Performance

2010-12-10 Thread Adarsh Sharma
Dear all, Performance tuning is what, which all i sured to achieve in pgsql. I am currently testing on 5 GB table with select operation that takes about 229477 ms ( 3.82 minutes ) with simple configuration. I have 4 GB RAM. So I change some parameters such as shared_buffers to 512 MB ,

Re: [GENERAL] Cannot Achieve Performance

2010-12-10 Thread Szymon Guz
On 10 December 2010 12:28, Adarsh Sharma adarsh.sha...@orkash.com wrote: Dear all, Performance tuning is what, which all i sured to achieve in pgsql. I am currently testing on 5 GB table with select operation that takes about 229477 ms ( 3.82 minutes ) with simple configuration. I have 4