| From: | Thomas Swan <tswan(at)idigx(dot)com> |
|---|---|
| To: | sdv mailer <sdvmailer(at)yahoo(dot)com> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, 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 16:54:52 |
| Message-ID: | 409A6DDC.4030602@idigx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
sdv mailer wrote:
>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 have SSL enabled on the postgresql server? If you do, this would
account for the slower connect time over TCP/IP.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-05-06 16:56:39 | Re: ALTER TABLE TODO items |
| Previous Message | Tom Lane | 2004-05-06 16:51:59 | Re: ALTER TABLE TODO items |