using more then one CPU for queries

From: stig erikson <stigerikson_nospam_(at)yahoo(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: using more then one CPU for queries
Date: 2005-12-10 21:17:18
Message-ID: dnfggd$hoq$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

from what i understand PostgreSQL only uses one CPU for any one query.

i do understand that on systems where there are many more connections
and simultaneous transactions (relatively small transactions) then the
number of processors, the queries would most likely run on a single
processor even if more processors were available.
on systems with many long running queries (possibly analytical) the same
would apply.

but on systems with relatively few queries compared to the number of
processors or on systems that have many small queries running and a few
large it could help run the large queries on more then one processor.

i would like to ask if there are some plans or if there has been any
discussions about allowing any one query to run on more then one processor?

tia.
stig

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Przeździecki 2005-12-10 22:00:38 Re: random delays
Previous Message Benjamin Arai 2005-12-10 20:27:09 Maximum number of tables per database and slowness