Re: performance degradation after launching postgres cluster using pgpool-II - Mailing list pgsql-performance

From Tatsuo Ishii
Subject Re: performance degradation after launching postgres cluster using pgpool-II
Date
Msg-id 20140407.224610.2291121243020563456.t-ishii@sraoss.co.jp
Whole thread Raw
In response to performance degradation after launching postgres cluster using pgpool-II  (Cora Ma <machengcheng001@hotmail.com>)
Responses Re: performance degradation after launching postgres cluster using pgpool-II  (Cora Ma <machengcheng001@hotmail.com>)
List pgsql-performance
> Before starting the cluster, one bulk updates through java code would cost
> about 1 hour to finish, but then it would take twice amount of time.

pgpool-II is not very good at handling extended protocol (mostly used
in Java). If you need to execute large updates, you'd better to
connect to PostgreSQL directly. Note that there's no problem that some
sessions connect via pgpool-II, while others directly connect
PostgreSQL.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: PGSQL 9.3 - Materialized View - multithreading
Next
From: Nicolas Paris
Date:
Subject: Re: PGSQL 9.3 - Materialized View - multithreading