Improving performance of postgresql

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

  • TSLSA-2005-0003 - multi
    ... Package name: bind clamav cpio cups mod_python perl postgresql python ... BIND includes a DNS server, ... Mod_python is a module that embeds the Python language interpreter within ...
    (Bugtraq)
  • Re: Re: help choosing OLAP solutions that run on/with pgsql
    ... > for MSTR ... > Application server if need be. ... > and the underlying database itself. ... > Using a combination of PostGreSQL for the warehouse and Jasper ...
    (comp.databases.olap)
  • Re: 2 x quad-core system is slower that 2 x dual core on FreeBSD
    ... We noticed the slowdown after moving PostgreSQL from 2xXeon 3.0 Apache+PostgreSQL server to dedicated PostgreSQL server. ... PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND ... r p d s w Csw Trp Sys Int Sof Flt 222 cow 16147 total ...
    (freebsd-stable)
  • Re: Python Database Apps
    ... What is your favorite python - database combination? ... make an app that has a local DB and a server side DB. ... I have had a lot of good luck with PostgreSQL. ... If an app comes already designed for mysql, oracle, sqlite, db2, dbm, ...
    (comp.lang.python)
  • Re: VB6, VB2005, or Something Else?
    ... Slashdot had a blurb yesterday about a new ... It's a book to help guide VB6 developers in the ... I then found a web host who would install PostgreSQL ... OLEDB on their W2K3 server which would give me remote access. ...
    (microsoft.public.vb.general.discussion)