Re: SELECT constant; takes 15x longer on 9.0? - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: SELECT constant; takes 15x longer on 9.0?
Date
Msg-id q2pb42b73151004060607p5150565fl53d07782ed732daf@mail.gmail.com
Whole thread Raw
In response to SELECT constant; takes 15x longer on 9.0?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: SELECT constant; takes 15x longer on 9.0?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Tue, Apr 6, 2010 at 1:47 AM, Josh Berkus <josh@agliodbs.com> wrote:
> Hackers,
>
> 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 ).

did your pings change?  on my machine the query ';' completes in about
0.05ms but any select takes 0.19 - 0.25ms.

0.77 is awfully high -- there has to be an explanation.

merlin


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per
Next
From: Simon Riggs
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Check compulsory parameters in recovery.conf in standby_mode, per