PostgreSQL pre-fork speedup

From: sdv mailer <sdvmailer(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PostgreSQL pre-fork speedup
Date: 2004-05-03 04:11:27
Message-ID: 20040503041127.33610.qmail@web60205.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I had lots of trouble posting so you may receive this
more than once. My apologies..
------------------------------

Hi,

I know the issue of pre-fork PostgreSQL has been
discussed previously.
Someone mentionned pre-fork can be implemented when
schemas become available
in PostgreSQL because there will be less of the need
to run multiple
databases.

I think Oracle 7 uses pre-forking and it helps speed
up the startup time
considerably. Often, there are cases where connection
pooling or persistent
connection cannot be used efficiently (e.g. replicated
or splitted databases
over hundreds of machines or where persistent
connection opens up too many
idle connections). Instead, there's a big need to
create a new connection on
every query and with PostgreSQL needing to fork on
every incoming connection
can be quite slow.

This could be a big win since even a moderate
improvement at the connection
level will affect almost every user. Any chance of
that happening for 7.5?

Thanks.



__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin Sherry 2004-05-03 04:14:18 Re: ANALYZE locks pg_listener in EXCLUSIVE for long time?
Previous Message Philip Warner 2004-05-03 04:09:26 Re: ANALYZE locks pg_listener in EXCLUSIVE for long