| From: | Ycrux <ycrux(at)club-internet(dot)fr> |
|---|---|
| To: | Marcos <mjs_ops(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Turn OFF Stats of Postgresql |
| Date: | 2006-03-14 20:28:24 |
| Message-ID: | 44172768.3010307@club-internet.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | josue | 2006-03-14 20:35:56 | audit system for parent-child tables |
| Previous Message | Bryan White | 2006-03-14 20:18:31 | Re: Resetting priveleges on a table |