Re: Weird 8.2.4 performance

On Wed, Jun 06, 2007 at 07:27:27PM -0400, Kurt Overberg wrote:
> This query runs great on production under 8.0 (27ms), but under 8.2.4
> (on my mac) I'm seeing times in excess of 50,000ms.  Note that on
> 8.2.4, if I run the query again, it gets successively faster
> (50,000ms->6000ms->27ms).  Is this normal?

Your production server probably has all the data in your cache, and your Mac
has not. Furthermore, they seem to be running on different data sets, judging
from your EXPLAIN ANALYZE.

How big did you say these tables were?

/* Steinar */
--
Homepage: http://www.sesse.net/