| From: | sdv mailer <sdvmailer(at)yahoo(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Rod Taylor <pg(at)rbt(dot)ca>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>, steve(at)blighty(dot)com, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL pre-fork speedup |
| Date: | 2004-05-06 17:06:41 |
| Message-ID: | 20040506170641.29916.qmail@web60203.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
I compared against both TCP and UNIX direct
connections. No SSL, no authentication. See benchmark
results posted below again:
Direct
------
0.144 sec. Client <--UNIX--> PG
0.152 sec. Client <--TCP--> PG
5x Faster
---------
0.027 sec. Client <--UNIX--> Pgpool <--UNIX--> PG
0.028 sec. Client <--UNIX--> Pgpool <--TCP--> PG
15x Slower
----------
2.39 sec. Client <--TCP--> Pgpool <--UNIX--> PG
2.40 sec. Client <--TCP--> Pgpool <--TCP--> PG
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Robinson | 2004-05-06 17:07:42 | Re: PostgreSQL pre-fork speedup |
| Previous Message | sdv mailer | 2004-05-06 16:58:33 | Re: PostgreSQL pre-fork speedup |