Josh Berkus <j...@agliodbs.com> writes: > Continuing the performance test:
> DBD, like a number of monitoring systems, does "pings" on the database > which look like this: > SELECT 'DBD::Pg ping test'; > In our test, which does 5801 of these pings during the test, they take > an average of 15x longer to execute on 9.0 as 8.4 ( 0.77ms vs. 0.05ms ). There's something wrong with your test setup. Or, if you'd like me to think that there isn't, provide a self-contained test case. I ran a small program that does for (i = 0; i < 10000; i++) { res = PQexec(conn, "SELECT 'DBD::Pg ping test'"); PQclear(res); } and I only see a few percent difference between HEAD and 8.4.3, on two different machines. (It does appear that HEAD is a bit slower for this, which might or might not be something to worry about.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers