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
half a second to, well, at least 10 minutes or so at which point I give
up an cancel the
-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
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
SNIP
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 join syntax or
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
,
but it would certainly answer my question.
Eric
Dann Corbit wrote:
-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