On 10 December 2010 12:28, Adarsh Sharma <adarsh.sharma@xxxxxxxxxx> 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 GB RAM. So I change some parameters such as Âshared_buffers to Â512 MB , effective cache Âsize to 1024 MB and my separate log directory.
Would this is sufficient or I need something else to be changed.
But my output after changing these parameters is not what I am expecting of , it is 229971 ms ( 3.81 minutes ). Please help.
Waiting for some pointers until I am googling.
Thanks & Regards
Adarsh Sharma
show us explain and explain analyze of this query, maybe the problem is not in the memory settings
regards
SzymonÂ
