Re: Turn OFF Stats of Postgresql

Поиск
Список
Период
Сортировка
От Ycrux
Тема Re: Turn OFF Stats of Postgresql
Дата
Msg-id 44172768.3010307@club-internet.fr
обсуждение исходный текст
Ответ на Turn OFF Stats of Postgresql  (Marcos <mjs_ops@gmx.net>)
Ответы Re: Turn OFF Stats of Postgresql  (Marcos <mjs_ops@gmx.net>)
Список 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
>
>


В списке pgsql-general по дате отправления:

Предыдущее
От: Marcos
Дата:
Сообщение: Turn OFF Stats of Postgresql
Следующее
От: josue
Дата:
Сообщение: audit system for parent-child tables