From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Cc: Kurt Overberg <kurt@hotdogrecords.com>
Subject: Re: Weird 8.2.4 performance
Date: Thu, 7 Jun 2007 11:43:04 +0200
Message-ID: <20070607094304.GA22543@uio.no> (raw)
In-Reply-To: <20070607093527.GA22482@uio.no>
References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com>
<20070607093527.GA22482@uio.no>
On Thu, Jun 07, 2007 at 11:35:27AM +0200, Steinar H. Gunderson wrote:
> How big did you say these tables were?
Sorry, you already said that -- 650k rows for one of them. If that table
doesn't fit in the cache on your Mac, you pretty much lose. From the EXPLAIN
output, it looks like it fits very nicely in cache on your server. Thus, I
don't think the difference is between 8.0 and 8.2, but rather your production
server and your test machine.
/* Steinar */
--
Homepage: http://www.sesse.net/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sgunderson@bigfoot.com, kurt@hotdogrecords.com
Subject: Re: Weird 8.2.4 performance
In-Reply-To: <20070607094304.GA22543@uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox