Postgres Pro
Downloads
Home   >   mailing lists

Performance tuning in Pgsql - Mailing list pgsql-general

From Adarsh Sharma
Subject Performance tuning in Pgsql
Date
Msg-id 4D01DC91.6020509@orkash.com
Whole thread Raw
Responses Re: Performance tuning in Pgsql  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Import ID column data then convert to SEQUENCE?
Next
From: Scott Marlowe
Date:
Subject: Re: Performance tuning in Pgsql