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

2014-04-07 Thread Tatsuo Ishii
> 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 Postg

[PERFORM] performance degradation after launching postgres cluster using pgpool-II

2014-04-07 Thread Cora Ma
Hi, I am a freshman to postgresql, also pgpool-II. I have some performance issues once I bring in the pgpool-II to build the pg cluster. Here I post some system info and the configurations of postgresql and pgpool, hopping you can help me to solve this problem. BTW, I am using the postgres 9.2.4