Re: PostgreSQL pre-fork speedup - Mailing list pgsql-hackers

From sdv mailer
Subject Re: PostgreSQL pre-fork speedup
Date
Msg-id 20040506161956.49540.qmail@web60206.mail.yahoo.com
Whole thread Raw
In response to Re: PostgreSQL pre-fork speedup  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PostgreSQL pre-fork speedup  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: PostgreSQL pre-fork speedup  (James Robinson <jlrobins@socialserve.com>)
Re: PostgreSQL pre-fork speedup  (Thomas Swan <tswan@idigx.com>)
Re: PostgreSQL pre-fork speedup  (James Robinson <jlrobins@socialserve.com>)
Re: PostgreSQL pre-fork speedup  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Hi Bruce,

Sorry for the confusion because Rod asked a question
and I answered too quickly. This is what I mean.

15x Slower:
-----------
Client <--TCP--> PgPool <--UNIX--> PostgreSQL
Client <--TCP--> PgPool <--TCP--> PostgreSQL

5x Faster:
----------
Client <--UNIX--> PgPool <--UNIX--> PostgreSQL
Client <--UNIX--> PgPool <--TCP--> PostgreSQL


Hope this helps! Pgpool speeds up connection time by
5x with UNIX socket due to pre-fork and connection
pooling. However, pgpool slows down by 15x under TCP
socket for some unknown reason.



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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: alter table alter columns vs. domains
Next
From: Bruno Wolff III
Date:
Subject: Re: Bug in pg_dump 7.4