[Pgpool-general] slow pgpool-II-3.1

[Olivier NOEL]

2011/10/6 Guillaume Lelarge <guillaume at lelarge.info>:
> On Thu, 2011-10-06 at 14:56 +0200, Armin Nesiren wrote:
>> On Thu, Oct 6, 2011 at 2:48 PM, Guillaume Lelarge <guillaume at lelarge.info>wrote:
>>
>> > On Thu, 2011-10-06 at 14:36 +0200, Armin Nesiren wrote:
>> > > Hi everyone,
>> > >
>> > > I'm experiencing performance issues with pgpool-3.1
>> > > Problem is that when I connect through pgpool to database, database works
>> > > slower than
>> > > when I connect directly to master. In this test case, I have disabled
>> > node2,
>> > > just to check performance
>> > > directly and through pgpool.
>> > >
>> > > What can be a problem?
>> >
>> > If I understand correctly, you only have one PostgreSQL server. And your
>> > client goes through pgpool to reach the PostgreSQL server. How can you
>> > expect that it would work faster that one PostgreSQL server alone?
>> >
>> > It'll work faster only if you have more than one PostgreSQL server. And
>> > more than one client.
>>
>>
>> No, with two servers (two nodes) work slower, also with one server through
>> pgpool
>> work slower than directly, I would expect to work same through pgpool and
>> directly.
>>
>
> With one server and one client, through pgpool, that can't be the same.
> pgpool decodes all the client's queries, which takes some time. IOW,
> there is an overhead. But when you have lots of clients, they usually
> are faster. And really faster with more than one PostgreSQL server.

And it's not. Ok, there is some overhead, but it's veeery slow.

I have 3 servers (streaming replication) with 1 pgpool (dedicated
server with 8GB RAM)

> --
> Guillaume
>  http://blog.guillaume.lelarge.info
>  http://www.dalibo.com
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>