Neil Conway <neilc(at)samurai(dot)com> writes:
> Evidently the optimizer chooses a different plan in the presence of the
> WHERE clause, but that plan appears to be pretty bad. However, it is
> tough to say more without EXPLAIN output for both queries (if possible,
> get EXPLAIN ANALYZE output -- although this might take too long for the
> second query).
And the schemas for the tables involved --- without knowing what indexes
are available it's impossible to guess much.
> Also, have you run ANALYZE recently?
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Barry Brown||Date: 2005-02-22 00:55:37|
|Subject: BUG #1498: Default permissions allow any user to create objects in any database (revised)|
|Previous:||From: Neil Conway||Date: 2005-02-22 00:44:13|
|Subject: Re: BUG #1482: SQL ERROR IN 7.4.7|