| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | sdv mailer <sdvmailer(at)yahoo(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, Rod Taylor <pg(at)rbt(dot)ca>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, steve(at)blighty(dot)com |
| Subject: | Re: PostgreSQL pre-fork speedup |
| Date: | 2004-05-06 18:34:14 |
| Message-ID: | F9B4EB16-9F8B-11D8-A5C9-000D9366F0C4@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On May 6, 2004, at 1:06 PM, sdv mailer wrote:
> I compared against both TCP and UNIX direct
> connections. No SSL, no authentication. See benchmark
> results posted below again:
I recall your script only connected 20 times - that is not enough to
filter out "noise" in those numbers. Please run it again, this time
with say, 1000 connects. That will give a more true number.
And also try running several of these in parellel.
I've been using pgpool in production with great success and it can
drastically improve connect times.
--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-05-06 18:39:29 | Re: alter table alter columns vs. domains |
| Previous Message | Tom Lane | 2004-05-06 18:26:56 | Re: PostgreSQL pre-fork speedup |