No analyze for 7.1.3.
Just ran vacuum a few minutes before the query. No boost at all. Even
with SET enable_seqscan = 0 it still does a table scan.
Dann, I can attest to 7.2 having a much better planner and performance
than 7.1 did. Can you upgrade?
---(end of
-Original Message-
From: scott.marlowe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 6:30 AM
To: Dann Corbit
Cc: johnn; [EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
What am I doing wrong?
No analyze for 7.1.3.
Just ran
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
NOTICE: QUERY PLAN:
SetOp Except (cost=202028537.97..202120623.90 rows=1227812 width=24)
- Sort (cost=202028537.97..202028537.97 rows=12278124 width=24)
- Append (cost=1.00..200225099.24 rows=12278124
-Original Message-
From: johnn [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 3:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
What am I doing wrong?
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
NOTICE
Dann Corbit [EMAIL PROTECTED] writes:
No analyze for 7.1.3.
Just ran vacuum a few minutes before the query. No boost at all.
VACUUM or VACUUM ANALYZE? Standalone ANALYZE was not in 7.1 but
VACUUM ANALYZE does what you need to do...
-Doug
---(end of
johnn [EMAIL PROTECTED] writes:
On Tue, Jan 07, 2003 at 03:10:06PM -0800, Dann Corbit wrote:
- Seq Scan on CNX_DS_53_SIS_STU_OPT_FEE_TB a
(cost=1.00..100112549.62 rows=6139062 width=24)
Those big round numbers suggest that you haven't run vacuum analyze on
all of your tables.
-Original Message-
From: Jean-Luc Lachance [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 2:43 PM
To: Tom Lane
Cc: Dann Corbit; Nigel J. Andrews;
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [GENERAL] [HACKERS] I feel the need for speed.
What am I doing wrong
--On Tuesday, January 07, 2003 15:25:06 -0800 Dann Corbit
[EMAIL PROTECTED] wrote:
No analyze for 7.1.3.
Just ran vacuum a few minutes before the query. No boost at all. Even
with SET enable_seqscan = 0 it still does a table scan.
did you do VACUUM ANALYZE?
If not, the stats weren't