Re: Improving performance of postgresql



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.

_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"



Relevant Pages

  • Re: Benchmark MySQL Performance On FreeBSD And Linux
    ... > check to see if you reached the default 1500 threading limit of libthr ... there is a general stability problem with libpthread. ... have had mysql lockups until I tinkered with the threading settings. ...
    (freebsd-performance)
  • Re: libpthread vs libthr.
    ... figure out why libthr in it current state is not our default posix ... the library by default is the source of a bad myth that threading model ... Another interesting question is which of the libraries will better work ... System scope appears to make mysql hog the system and everything slows ...
    (freebsd-current)
  • Re: BSD vs Linux Threads
    ... >>> Well in the past it was stated that on a MySQL server installed using ... >>> wanting to know if using the Linux threads was still faster. ... >> It probably is because mysql is optimized for the Linux threading ... >> Also keep in mind that freebsd filesystems are mounted async by default, ...
    (freebsd-questions)
  • Re: libpthread vs libthr.
    ... figure out why libthr in it current state is not our default posix ... the library by default is the source of a bad myth that threading model ... Another interesting question is which of the libraries will better work ... System scope appears to make mysql hog the system and everything slows ...
    (freebsd-current)
  • Re: Problems with MySQL since upgrade
    ... the query usually proceeds normally; it's only when it doesn't that things go bad. ... I'm wondering if this is a problem with threads -- I've been doing research, and a number of places say that there are threading issues on FreeBSD 5 with MySQL thread when using the standard threading library. ... On Aug 2, 2006, at 10:00 AM, Jim Stapleton wrote: ...
    (freebsd-questions)