> -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?
>
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 t
"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 broadcast)-
> -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:06
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: 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 spee