On 26.01.2011 16:46, Felix Schmidt @ Oracle wrote:
> I'm interested in the query optimizer of PostgreSQL DB. Where could I
> find useful documentation or could you send me a pointer in the source code?
The relevant source code is in src/backend/optimizer directory. If you
google around, you'll find introductory presentations, but I can't
recommend any particular one.
> What kind of parallelism does PostgreSQL use for operators, like
> selection or join?
The short answer is "none". Each PostgreSQL backend is a one
single-threaded process, one query will only utilize one CPU
If you search the archives, you'll find discussion on how it might one
day be improved, but nothing concrete has been done.
In response to
pgsql-hackers by date
|Next:||From: Alexey Klyukin||Date: 2011-01-27 10:38:53|
|Subject: Re: arrays as pl/perl input arguments [PATCH]|
|Previous:||From: Boszormenyi Zoltan||Date: 2011-01-27 10:21:44|
|Subject: make -j2 error in ecpg/pgtypeslib in current GIT|