Re: [PERFORM] Utilizing multiple cores for one query

2007-12-10 Thread Marko Kreen
On 12/1/07, Jonah H. Harris <[EMAIL PROTECTED]> wrote: > Currently, the only way to parallelize a query in Postgres is to use > pgpool-II. FYI: plproxy issues queries for several nodes in parallel too. -- marko ---(end of broadcast)--- TIP 6: exp

Re: [PERFORM] Utilizing multiple cores for one query

2007-12-04 Thread Matthew
On Sat, 1 Dec 2007, Jonah H. Harris wrote: > I believe the threads you're talking about were related to scanning, > not parallel query. Though, when Qingqing and I were discussing > parallel query a little over a year ago, I do seem to recall several > uninformed opinions stating that sequential s

Re: [PERFORM] Utilizing multiple cores for one query

2007-12-01 Thread Jean-David Beyer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 henk de wit wrote: >> > 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? >> Nope. > > I see, thanks for the clarification. > > Btw, in this threa

Re: [PERFORM] Utilizing multiple cores for one query

2007-12-01 Thread Jonah H. Harris
On Dec 1, 2007 9:42 AM, henk de wit <[EMAIL PROTECTED]> wrote: > Wouldn't this offer some opportunities for running things on multiple cores? No, it's not actually parallel in the same sense. > Yes, I noticed this project before. At the time it was not really clear how > stable and/or how well su

Re: [PERFORM] Utilizing multiple cores for one query

2007-12-01 Thread henk de wit
> > 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? > Nope. I see, thanks for the clarification. Btw, in this thread: http://archives.postgresql.org/pgsql-performance/2007-10/msg00159.php the

Re: [PERFORM] Utilizing multiple cores for one query

2007-12-01 Thread Jonah H. Harris
On Dec 1, 2007 8:21 AM, henk de wit <[EMAIL PROTECTED]> wrote: > 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? Nope. > This is one thing that systems like SQL Server and Oracle have been able to

[PERFORM] Utilizing multiple cores for one query

2007-12-01 Thread henk de wit
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 hin