Julius Stroffek wrote: > Hi All, > > we would like to start some work on improving the performance of > PostgreSQL in a multi-CPU environment. Dano Vojtek is student at the > Faculty of Mathematics and Physics of Charles university in Prague > (http://www.mff.cuni.cz) and he is going to cover this topic in his > master thesis. He is going to do some investigation in the methods and > write down the possibilities and then he is going to implement something > from that for PostgreSQL. > > We want to come out with a serious proposal for this work after > collecting the feedback/opinions and doing the more serious investigation.
Exciting stuff, and clearly a direction we need to explore. > Topics that seem to be of interest and most of them were already > discussed at developers meeting in Ottawa are > 1.) parallel sorts > 2.) parallel query execution > 3.) asynchronous I/O I think the current plan is to use posix_advise() to allow parallel I/O, rather than async I/O becuase posix_advise() will require fewer code changes. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
