Statements execution pausing¶

since 1.4.1

Sometimes you need to pause statements execution, ex: with Postgresql minor update. This only possible for transactional pooling because the connections to pg server will be reset anyway.

To stop Odyssey execution you will need console configured and paused user must have transactional pooling.

Configuration¶

Lets assume you have next parts of your configuration:

...

storage "local" {
    type "local"
}

database "console" {
    user "console" {
        authentication "none"
        role "admin"
        pool "session"
        storage "local"
    }
}

...

database "postgres" {
    user "postgres" {
        authentication "none"
        pool "transactional"
        storage "postgres_server"
    }
}

...

Pausing¶

Just execute:

psql 'host=localhost port=6432 user=console dbname=console' -c 'pause'

How does it looks for client connections?¶

Just like currently transaction finished and new transactions sleeps until Odyssey resumed. For:

pgbench 'host=localhost port=6432 user=postgres dbname=postgres sslmode=disable' --progress 1

runs it looks like:

progress: 1.0 s, 13685.2 tps, lat 0.569 ms stddev 3.550, 0 failed
+ psql -h localhost -p 6432 -c pause -U console -d console
progress: 2.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
progress: 3.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
...
progress: 7.0 s, 0.0 tps, lat 0.000 ms stddev 0.000, 0 failed
+ psql -h localhost -p 6432 -c resume -U console -d console
progress: 8.0 s, 4165.3 tps, lat 17.347 ms stddev 344.607, 0 failed
progress: 9.0 s, 22651.8 tps, lat 0.441 ms stddev 0.066, 0 failed
progress: 10.0 s, 23471.7 tps, lat 0.425 ms stddev 0.053, 0 failed

Resuming¶

Just execute:

psql 'host=localhost port=6432 user=console dbname=console' -c 'resume'

State checking¶

Just execute:

psql 'host=localhost port=6432 user=console dbname=console' -c 'show is_paused'