Dann,
Thanks for your response. I thought I'd covered most of what your are
asking in my first message, but these results are weird enough that I
can understand you might not give me the benefit of the doubt and
without very explicit confirmation. To answer your questions:
YES the query each time
On Fri, Oct 31, 2008 at 04:36:02PM -0400, Eric Schwarzenbach wrote:
> As I explained already (no pun intended) running the query using EXPLAIN
> makes the wild variation go away. So I cannot get explain results for a
> fast and for a slow execution.
EXPLAIN only determines and outputs the query pl
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Fri, Oct 31, 2008 at 1:34 PM, Eric Schwarzenbach
> <[EMAIL PROTECTED]> wrote:
>> This is postgreslq 8.3, on Windows XP. The query joins about 17 tables
>> (without an explicit JOIN, just using the WHERE criteria) with a few
> OK, whether you use joi
On Fri, Oct 31, 2008 at 1:34 PM, Eric Schwarzenbach
<[EMAIL PROTECTED]> wrote:
> I've got a particular query that is giving me ridiculously erratic query
> performance. I have the SQL in a pgadmin query window, and from one
> execution to another, with no changes, the time it takes varies from
SNI
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Eric Schwarzenbach
> Sent: Friday, October 31, 2008 12:35 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Wildly erratic query performance
>
> I've got a particular query that
