From: Robert Davis <robert@faithwestinc.com>
To: pgsql-sql@postgresql.org
Subject: explain analyze results are different for each iteration
Date: Tue, 14 Sep 2004 18:21:27 -0700
Message-ID: <41479917.7010305@faithwestinc.com> (raw)
I'm trying to benchmark some complex sql queries. One query, in
particular, is causing problems -- its cost values can vary from 228
to 907, its Total Runtimes from 60 ms to 5176 ms. The query plans
show that the optimizer is choosing different plans for different
iterations of the same query. Does anyone have any idea what's
going on here or maybe how I can force Postgres to prefer the faster
plan?
The query plans are very long (11 tables joined) but I can include
them if it might help. Thanks for any advice,
Roberto
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-sql@postgresql.org
Cc: robert@faithwestinc.com
Subject: Re: explain analyze results are different for each iteration
In-Reply-To: <41479917.7010305@faithwestinc.com>
* 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