Re: One or more processor ?

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Hervé Piedvache <herve(at)elma(dot)fr>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: One or more processor ?
Date: 2003-10-10 16:35:50
Message-ID: Pine.BSF.4.44.0310101235010.77861-100000@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Hervé Piedvache 2003-10-10 16:36:11 PostgreSQL Scalable ?
Previous Message Hervé Piedvache 2003-10-10 16:30:49 One or more processor ?