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.klaver@gmail.com