Horton

Re: CREATE INDEX spoils IndexScan planns

Rod Taylor <rbt@rbt.ca>

View thread View on postgr.es
From: Rod Taylor <rbt@rbt.ca>
To: Nitz <nitz@siol.net>
Cc: pgsql-bugs@postgresql.org
Date: 2003-10-31T13:29:34Z
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.