Re: PostgreSQL pre-fork speedup

From: sdv mailer <sdvmailer(at)yahoo(dot)com>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgman(at)candle(dot)pha(dot)pa(dot)us, pg(at)rbt(dot)ca, scott(dot)marlowe(at)ihs(dot)com, steve(at)blighty(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL pre-fork speedup
Date: 2004-05-12 14:54:16
Message-ID: 20040512145416.34836.qmail@web60205.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I ran the new Pgpool-1.2.2 and it was a bit faster on
the TCP but still slower than on UNIX socket. I used
the same script as before.

TCP Socket (Pgpool 1.2.0)
----------
2.39 sec

TCP Socket (Pgpool 1.2.2)
----------
0.80 sec
0.80 sec
0.79 sec

UNIX Socket (Pgpool 1.2.2)
-----------
0.026 sec
0.027 sec
0.027 sec

Direct TCP connection (no pgpool)
---------------------------------
0.16 sec
0.15 sec
0.16 sec

PgPool on TCP is still slower than direct connection
but much faster than v1.2. Any other areas that can be
improved?

Regards,



__________________________________
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2004-05-12 14:55:34 Re: Subtle pg_dump problem...
Previous Message Larry Rosenman 2004-05-12 14:49:52 threads stuff/UnixWare