postgresql - PostreSQL with PgPool running extremely slow -

postgresql - PostreSQL with PgPool running extremely slow -

i'm running tests on postgresql see if feasible replacement mysql on rather busy server. have next configuration:

postgresql max_connections = 10 pgpool num_init_children = 8 max_pool = 100

i have feeling setup less optimal since benchmarking proving extremely slow.

running ab -c 50 -n 10000 took over 15 minutes

whereas same test, on same server connecting mysql takes 1 second!

note: each ab request insert statement. aslo have changed settings following, results have not improved

postgresql max_connections = 100 pgpool num_init_children = 32 max_pool = 4

the hardware has 12gb ram , intel xeon 2.40ghz.

postgresql pgpool