pgbouncer degrades while -T is used - Mailing list pgsql-admin

From Tejaswi K T
Subject pgbouncer degrades while -T is used
Date
Msg-id CAFxeN6SMXkJHpjybCinUZHZzsoD_BkkdvZb0usJ=0AEWc5B-=Q@mail.gmail.com
Whole thread Raw
Responses Re: pgbouncer degrades while -T is used
List pgsql-admin
Hi Friends, new to postgres -

installed pgbouncer and was trying some options there.
Tested with below commands and pgbouncer excels the direct postgres connections

can someone explain why pgbouncer degrades while -T is used

---works good for pgbouncer
pgbench -c 20 -t 100 -S mydatabase -h 127.0.0.1 -p 5432 -U myuser -C -f mysql.sql
pgbench -c 20 -t 100 -S mydatabase -h 127.0.0.1 -p 6432 -U myuser -C -f mysql.sql
---works good for pgbouncer
pgbench -c 20 -t 100 -S mydatabase -h 127.0.0.1 -p 5432 -U myuser -C
pgbench -c 20 -t 100 -S mydatabase -h 127.0.0.1 -p 6432 -U myuser -C


But pgbouncer fails while using -T (duration) when pgbench testing:

---works good without pgbouncer
pgbench -c 20 -T 60 -S mydatabase -h 127.0.0.1 -p 5432 -U myuser
pgbench -c 20 -T 60 -S mydatabase -h 127.0.0.1 -p 6432 -U myuser

---

postgres@oracle-VirtualBox:~$ pgbench -c 20 -T 60 -S mydatabase -h 127.0.0.1 -p 5432 -U myuser
Password:
pgbench (16.1 (Ubuntu 16.1-1.pgdg20.04+1))
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 10
query mode: simple
number of clients: 20
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 474592
number of failed transactions: 0 (0.000%)
latency average = 2.521 ms
initial connection time = 246.002 ms
tps = 7933.834914 (without initial connection time)


With pgbouncer below TPS is degraded
postgres@oracle-VirtualBox:~$ pgbench -c 20 -T 60 -S mydatabase -h 127.0.0.1 -p 6432 -U myuser
Password:
pgbench (16.1 (Ubuntu 16.1-1.pgdg20.04+1))
starting vacuum...end.
transaction type: <builtin: select only>
scaling factor: 10
query mode: simple
number of clients: 20
number of threads: 1
maximum number of tries: 1
duration: 60 s
number of transactions actually processed: 367541
number of failed transactions: 0 (0.000%)
latency average = 3.258 ms
initial connection time = 133.730 ms
tps = 6138.123161 (without initial connection time)

Thanks in advance
Tejas

pgsql-admin by date:

Previous
From: Sunil Jadhav
Date:
Subject: Re: Required distinct record with all fields
Next
From: Tejaswi K T
Date:
Subject: Re: pgbouncer degrades while -T is used