Turn OFF Stats of Postgresql

Started by Marcosabout 20 years ago4 messagesgeneral
Jump to latest
#1Marcos
mjs_ops@gmx.net

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

#2Ycrux
ycrux@club-internet.fr
In reply to: Marcos (#1)
Re: Turn OFF Stats of Postgresql

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?

http://www.postgresql.org/docs/faq

#3Chris
dmagick@gmail.com
In reply to: Marcos (#1)
Re: Turn OFF Stats of Postgresql

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/

#4Marcos
mjs_ops@gmx.net
In reply to: Ycrux (#2)
Re: Turn OFF Stats of Postgresql

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=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 :

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?

http://www.postgresql.org/docs/faq