Re: One or more processor ? - Mailing list pgsql-performance

From Jeff
Subject Re: One or more processor ?
Date
Msg-id Pine.BSF.4.44.0310101235010.77861-100000@torgo.978.org
Whole thread Raw
In response to One or more processor ?  (Hervé Piedvache <herve@elma.fr>)
List pgsql-performance
On Fri, 10 Oct 2003, [iso-8859-15] Herv� Piedvache wrote:

> If I do a SQL request ... does PostgreSQL use one or more processor ?
>

Nope. Just one processor this is because PG is process not thread based.
However, if you opened 4 connections and each issued a sql statement all 4
processors would be used.  Check the -HACKERS archives for lengthy
discussions of this.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-performance by date:

Previous
From: Hervé Piedvache
Date:
Subject: One or more processor ?
Next
From: Hervé Piedvache
Date:
Subject: PostgreSQL Scalable ?