From: | sdv mailer <sdvmailer(at)yahoo(dot)com> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: PostgreSQL pre-fork speedup |
Date: | 2004-05-06 05:22:39 |
Message-ID: | 20040506052239.58127.qmail@web60205.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I don't think I can volunteer on this end as I am
already actively volunteering for another open
project. I was hoping someone could take up on this
since one of the last threads mentionned we don't have
something substantial to present for 7.5 if June 1 is
dateline for code freeze. Pre-fork came to mind. :-)
As for proof of concept, I think pgpool from Tatsuo
Ishii is a good indication that pre-fork works. I'll
try to see if I can generate some benchmarks using
pgpool on my Linux.
PgPool is a server-side connection pool/load
balancer/replicator that implements pre-fork but
because it acts as a proxy there is 7% to 15% overhead
according to his README file.
http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg44082.html
--- Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> sdv mailer wrote:
>
> [snip]
>
> >Pre-fork will give MySQL one less argument to throw
> at
> >PostgreSQL.
> >
> >I think optimizing is this area will speed up the
> >general case for everyone rather than optimizing a
> >feature that affects 10% of the users. On top of
> that,
> >it will make a strong marketing case because
> forking
> >will no longer become a speed issue when compared
> to
> >MySQL.
> >
> >
> >
>
> So when can we expect to see your proof of concept
> code and benchmarks
> to show the speedup achieved?
>
> cheers
>
> andrew
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
settings
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-05-06 05:30:20 | Re: PostgreSQL pre-fork speedup |
Previous Message | sdv mailer | 2004-05-06 04:56:34 | Re: PostgreSQL pre-fork speedup |