Turn OFF Stats of Postgresql
Hi,
I have a search engine and for increase the performance I want to turn
off the stats of Postgresql but i don't know if i should do it.
Should I make this?
Thanks.
Marcos
Ho Marcos!
You can also try to adpat this parameters to your config:
TUNING:
* First, see:
http://www.lyris.com/lm_help/6.0/tuning_postgresql.html
* Adjust this params in your "/etc/sysctl.conf" to obtain the
best performances:
kernel.shmmax=70000000
kernel.shmall=13500000
net.core.rmem_max=8388608
net.core.rmem_default=65536
net.core.wmem_max=8388608
net.core.wmem_default=65536
* Adapt and copy the "postgresql.conf" to your
"/var/pgsql/data" directory.
Younes
Marcos a �crit :
Show quoted text
Hi,
I have a search engine and for increase the performance I want to turn
off the stats of Postgresql but i don't know if i should do it.Should I make this?
Thanks.
Marcos
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
Marcos wrote:
Hi,
I have a search engine and for increase the performance I want to turn
off the stats of Postgresql but i don't know if i should do it.
Edit your postgresql.conf file, turn them off and then restart postgresql.
--
Postgresql & php tutorials
http://www.designmagick.com/
Hi Ycrux
Thank very much for your help.
Marcos
Em Ter, 2006-03-14 �s 21:28 +0100, Ycrux escreveu:
Show quoted text
Ho Marcos!
You can also try to adpat this parameters to your config:TUNING:
* First, see:
http://www.lyris.com/lm_help/6.0/tuning_postgresql.html* Adjust this params in your "/etc/sysctl.conf" to obtain the
best performances:kernel.shmmax=70000000
kernel.shmall=13500000net.core.rmem_max=8388608
net.core.rmem_default=65536
net.core.wmem_max=8388608
net.core.wmem_default=65536* Adapt and copy the "postgresql.conf" to your
"/var/pgsql/data" directory.Younes
Marcos a �crit :
Hi,
I have a search engine and for increase the performance I want to turn
off the stats of Postgresql but i don't know if i should do it.Should I make this?
Thanks.
Marcos
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?