From: Alvaro Herrera <alvherre@commandprompt.com>
To: Patrick Donlin <pdonlin@oaisd.org>
Cc: Kevin Grittner <kevin.grittner@wicourts.gov>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Identical query slower on 8.4 vs 8.3
Date: Thu, 15 Jul 2010 11:21:33 -0400
Message-ID: <1279207110-sup-2392@alvh.no-ip.org> (raw)
In-Reply-To: <1123546138.13276371279206773000.JavaMail.root@mm-mailstore02.merit.edu>
References: <1123546138.13276371279206773000.JavaMail.root@mm-mailstore02.merit.edu>
Excerpts from Patrick Donlin's message of jue jul 15 11:12:53 -0400 2010:
> I'll read over that wiki entry, but for now here is the EXPLAIN ANALYZE output assuming I did it correctly. I have run vacuumdb --full --analyze, it actually runs as a nightly cron job.
These plans seem identical (though the fact that the leading whitespace
was trimmed means it's untrustworthy -- please in the future send them
as text attachments instead so that your mailer doesn't interfere with
formatting). The 8.4 plan is even a full second faster, according to
the "total runtime" line.
The slowness could've been caused by caching effects ...
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: alvherre@commandprompt.com, pdonlin@oaisd.org, kevin.grittner@wicourts.gov
Subject: Re: Identical query slower on 8.4 vs 8.3
In-Reply-To: <1279207110-sup-2392@alvh.no-ip.org>
* 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