Re: CREATE INDEX spoils IndexScan planns - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: CREATE INDEX spoils IndexScan planns
Date
Msg-id 1067606974.16240.20.camel@jester
Whole thread Raw
In response to CREATE INDEX spoils IndexScan planns  (Nitz <nitz@siol.net>)
Responses Re: CREATE INDEX spoils IndexScan planns
List pgsql-bugs
> TRACE:
> The original tables are much bigger, so I've tried to simplify things her=
e.
> 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.

pgsql-bugs by date:

Previous
From: Nitz
Date:
Subject: CREATE INDEX spoils IndexScan planns
Next
From: Nitz
Date:
Subject: Re: CREATE INDEX spoils IndexScan planns