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

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: machengcheng001(at)hotmail(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance degradation after launching postgres cluster using pgpool-II
Date: 2014-04-07 13:46:10
Message-ID: 20140407.224610.2291121243020563456.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nicolas Paris 2014-04-07 13:56:43 Re: PGSQL 9.3 - Materialized View - multithreading
Previous Message Graeme B. Bell 2014-04-07 12:59:25 Re: PGSQL 9.3 - Materialized View - multithreading