Re: How to install latest stable postgresql on Debian

On Friday, November 18, 2011 3:58:26 pm Andrus wrote:
> >How did you uninstall 8.4?
> >From below it would seem it is still around.
>
> Thank you.
> After adding -t switch to apt-get I was able to install 9.1.
>
> To start it I invoked /etc/init.d/postgresql manually.
>
> How to force it to start after server is rebooted automatically ?
>
> free -g returns
>
> total used free shared buffers cached
> Mem: 2 0 2 0 0 0
> -/+ buffers/cache: 0 2
> Swap: 3 0 3
>
> Which parameters in postgresql.conf needs to be changed to work it as fast
> as posssible ? This is dedicated server.

The ones marked "greased lightning":) Sorry, could not resist.

For tuning tips a good start is:
http://wiki.postgresql.org/wiki/Performance_Optimization
In particular:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

For books take a look at:
http://www.postgresql.org/docs/books/

>
> Andrus.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com