Postgres Pro
Downloads
Home   >   mailing lists

Thread: Turn OFF Stats of Postgresql

Turn OFF Stats of Postgresql

From
Marcos
Date:
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

Re: Turn OFF Stats of Postgresql

From
Ycrux
Date:
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
>
>

Re: Turn OFF Stats of Postgresql

From
Chris
Date:
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/

Re: Turn OFF Stats of Postgresql

From
Marcos
Date:
Hi Ycrux

Thank very much for your help.

Marcos

Em Ter, 2006-03-14 às 21:28 +0100, Ycrux escreveu:
> 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
> >
> >
>