Dear all, I am researched a lot about Performance tuning in Pgsql.
I found that we have to change shared_buffer parameter and effective_cache_size parameter. I changed shared_buffer to 2 GB but I can't able to locate effective_cache_size parameter in postgresql.conf file.
Also i want to change my WAL directory to seperate directory. Same I couldn,t locate pg_xlog or how to change it.
I am very new to postgresql. Please help and guide me if any other thing needed for Make our Postgresql Server Faster and give better performance.
Thanks & Regards Adarsh Sharma -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general