12 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
138
views
pgvector stress test using pgbench with custom function or custom script
I am trying to run a stress test on a vector data type table. But not able to run pgbench with custom functions: random_between and random_array. Kindly suggest how to perform the stress test with ...
0
votes
0
answers
641
views
Connect() failed for backend test6432: no free ports
I'm trying to test connections on Postgres, I'm using Haproxy to redirect connections to master or slave. Testing with pgbench.
this command working well with 5000 clients:
/usr/bin/pgbench -h 127.0.0....
1
vote
0
answers
105
views
Postgres low performance on 13th gen i9
I use pgbench for Postgres 12 (default config) and the results are as follows:
pgbench -i -U postgres -s 50 db_test
pgbench -c 1 -j 1 -t 3000 -U postgres db_test
number of client: 1
number of thread: ...
1
vote
2
answers
2k
views
How to run pgbench from a pod without having to type the password every time [Kubernetes] [CloudNativePG] [closed]
I am a user of Kubernetes, and I am using the CloudNativePG operator version 1.20.1 with PostgreSQL. Currently, I am conducting tests on clusters using the pgbench tool. However, when I execute the ...
0
votes
1
answer
406
views
Unexpected Number of deadtuples after several updates
I have a question about the number of deadtuples after an update scenario in PGSQL.
Due to MVCC protocol in PGSQL, many updates cause the tables to bloat. We may track this with the number of dead ...
1
vote
0
answers
941
views
pgbench benchmark rises using pgbouncer
I've got Postgres 13 and PGbouncer.
When I make pgbench test, when I rise client connection and quantity of query,
tps also rises. Why?
For example:
pgbench -U postgres -h .... -p 6544 datafactory -c ...
0
votes
1
answer
2k
views
PgBouncer - Server DNS lookup failed
I am trying to test PgBouncer connection with pgbench on a PostgreSQL server. But I'm getting error as closing because: server DNS lookup failed and at pgbench getting this message:
pgbench -c 10 -t ...
0
votes
2
answers
292
views
pgbench select uuid for custom scripts
I am trying to benchmark a custom dataset with pgbench.
all the records I want to select for have uuids as primary keys.
Unfortunately all the samples snipets select random records by using random() ...
0
votes
1
answer
345
views
Does Pgbench modify the database?
I'm trying to generate "locks" in my postgresql database, i used pgbench to create an activity in the database while lanching a vacuum full or reindex to generate some process "locks&...
0
votes
1
answer
1k
views
pgBench Fatal: need at least 2003 open files, but system limit is 1024
Am trying to run some testing using a connection pooler (pgBouncer). I am trying to run for 2000 clients via pgBench.
When running the following:
./pgbench -h 172.1.1.9 pgbench -p 6432 --client=2000 --...
0
votes
1
answer
2k
views
How to get P99 latency result using pgbench?
I am trying to use pgbench to perform a test on PolarDB for postgreSQL.
This is the command I used to perform the test.
pgbench -M prepared -r -c 16 -j 4 -T 30 -p 10001 -d pgbench -l
And this is the ...
0
votes
2
answers
7k
views
How to use pgbench? [closed]
I have a table on pgadmin4 which consist of 100.000 lines and 23 columns.I need to benchmark postgresql on this specific table using pgbench,but i cant understand what parameters should i use.The ...