Re: CREATE INDEX spoils IndexScan planns

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Nitz <nitz(at)siol(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: CREATE INDEX spoils IndexScan planns
Date: 2003-10-31 13:29:34
Message-ID: 1067606974.16240.20.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


> TRACE:
> The original tables are much bigger, so I've tried to simplify things here.
> Please let me know if there is anything that I could help you with.

You can't do that and expect to get reasonable results. The plans will
change with the volume of data.

Send an explain analyze of the true problem after ANALYZE with seqscan
on and one with it off.

Thanks.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nitz 2003-10-31 17:25:24 Re: CREATE INDEX spoils IndexScan planns
Previous Message Nitz 2003-10-31 12:30:35 CREATE INDEX spoils IndexScan planns