Skip to content

Instantly share code, notes, and snippets.

@jfrost

jfrost/gist:e36a4fdd2812b64c3ac9

Created November 5, 2014 21:12
Show Gist options
  • Save jfrost/e36a4fdd2812b64c3ac9 to your computer and use it in GitHub Desktop.
Save jfrost/e36a4fdd2812b64c3ac9 to your computer and use it in GitHub Desktop.
Download ZIP
pgbouncer simple benchmark results
Raw
gistfile1.txt
So, I did a quick test with pgbouncer running on the local host and talking to a remote postgresql backend. I had the script open a connection, run a quick almost instantaneous query (SELECT now() ), collect the results and close the connection. It looped over this 50,000 times.
Connecting to the bouncer over local unix socket, it took 31s to perform all the queries.
Connecting to the bouncer over localhost, it took 45s to perform all the queries.
Connecting to the bouncer running on the remote server, it took 1m6s
Without using pgbouncer, it took 3m34s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment