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

From sdv mailer
Subject Re: PostgreSQL pre-fork speedup
Date
Msg-id 20040512145416.34836.qmail@web60205.mail.yahoo.com
Whole thread Raw
In response to Re: PostgreSQL pre-fork speedup  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: PostgreSQL pre-fork speedup
List 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 


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Subtle pg_dump problem...
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Subtle pg_dump problem...