mirror of
https://codeberg.org/scip/pgidler.git
synced 2025-12-16 12:01:01 +01:00
52 lines
1.6 KiB
Markdown
52 lines
1.6 KiB
Markdown
# pgidler
|
|
|
|
Create idle postgres connections for testing
|
|
|
|
## Introduction
|
|
|
|
This program start a number of idle (or idle in transaction) sessions
|
|
on a postgres database for testing purposes. It uses go routines (like
|
|
threads) to execute independent clients. Each client executes a number
|
|
of harmless SELECT's and then stops doing anything. The clients then
|
|
hang either forever or until a specified timeout is reached.
|
|
|
|
This is an implementation of a tool described at [AWS Blog: Performance impact of idle PostgreSQL connections](https://aws.amazon.com/blogs/database/performance-impact-of-idle-postgresql-connections/).
|
|
|
|
## Building
|
|
|
|
Run `make` to compile. You'll need Golang. The repo contains a
|
|
pre-compiled binary for linux amd.
|
|
|
|
## Usage
|
|
|
|
`pgidler` offers two idle modes:
|
|
|
|
- **idle**: create normal idle sessions
|
|
- **idle in transaction**: create sessions hanging in a transaction
|
|
|
|
The following commandline options are available:
|
|
```
|
|
Usage of ./pgidler:
|
|
-c, --client int Number of concurrent users (default 500)
|
|
-d, --database string Database (default "postgres")
|
|
-i, --idletransaction Wether to stay in idle in transaction state
|
|
-p, --password string Password of the database user
|
|
-P, --port int TCP Port (default 5432)
|
|
-s, --server string Server (default "localhost")
|
|
-t, --timeout int Wether to stop the clients after N seconds
|
|
-u, --user string Database user (default "postgres")
|
|
```
|
|
|
|
# Report bugs
|
|
|
|
[Please open an issue](https://codeberg.org/scip/pgidler/issues). Thanks!
|
|
|
|
# License
|
|
|
|
This work is licensed under the terms of the General Public Licens
|
|
version 3.
|
|
|
|
# Author
|
|
|
|
Copyleft (c) 2024 Thomas von Dein
|