> Tomek Lutelmowski wrote: > > On Sun, 5 Nov 2006 16:49:45 -0800, Lord Sauron wrote > >> On 11/5/06, Tomek Lutelmowski <[EMAIL PROTECTED]> wrote: > >>> Does anybody has any issues when switching to PostgreSQL 8.1 or pgpool > > 3.x ? > >>> I see PostgreSQL has threading support since 8.1, could you tell how does > > it > >>> affect performance? > > As far as we're aware of PostgreSQL does not have threading support. The > postgresql server is non-threaded (as opposed to MySQL which for example > is fully threaded). The threads support we're talking about here only > matters for the PgSQL libraries, so they are threadsafe and can be > included/used in other threaded applications, for example PHP. > New ebuilds for libpq/postgresql are on the way that will correctly > reflect this, only libpq will have a "threads" USE flag. > Also, you can use 8.1.4 without problems, it's just not stable yet > because we hadn't time to test it fully and ask for it to be stabled. > 8.1.5 will probably become stable during the next month/weeks.
This is correct. Here is a recent thread from the postgresql mailing list discussing a similar question about threading versus creating new proccesses for additional connections: http://archives.postgresql.org/pgsql-general/2006-10/msg01427.php As I understand it, newer releases of postgresql are continually improved to handle load balancing between multiple processors. Regards, Richard Broersma Jr. -- [email protected] mailing list
