Improving performance of postgresql

[Vittorio De Martino-2]

Under freebsd 6.1 on  a pentium 4 with 256 MB I compiled and installed a
postgresql (now 8.0.8) server which has been running wonderfully.

I tailored the conf files to tune the server with my hardware according to the
many suggestions I read in the net which are OS-independent that is that
apply to any *nix (or better linux-centric).

Now I would like to know if for a postgresql server there are settings more **
freebsd specif ic ** to improve performance.

Ciao
Vittorio.
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"

[Ivan Voras-2]

vittorio wrote:

> Now I would like to know if for a postgresql server there are settings more **
> freebsd specif ic ** to improve performance.

You can start from here: http://wiki.freebsd.org/Performance, in
particular read the MySQL page but ignore all points regarding threading
and threads.

_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"