From: | henk de wit <henk53602(at)hotmail(dot)com> |
---|---|
To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Utilizing multiple cores for one query |
Date: | 2007-12-01 13:21:21 |
Message-ID: | BAY124-W312F15BBE3D85AE1D472F8F5720@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I wonder whether the current versions of postgres (i.e. either 8.2 or 8.3) are able to utilize multiple cores for the execution of a single query?
This is one thing that systems like SQL Server and Oracle have been able to do for quite some time. I haven't seen much in the documentation that hints that this may be possible in PG, nor did I find much in the mailinglists about this. The only thing I found was a topic that discussed some patches that may eventually lead to a sequence scan being handled by multiple cores.
Could someone shed some light on the current or future abilities of PG for making use of multiple cores to execute a single query?
Thanks in advance
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Jonah H. Harris | 2007-12-01 13:31:13 | Re: Utilizing multiple cores for one query |
Previous Message | cluster | 2007-11-30 16:01:11 | Re: Appending "LIMIT" to query drastically decreases performance |