Search Postgresql Archives

Re: Turn OFF Stats of Postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux