1) Have you recently run an analyze?
2) Are you sure that an index scan would be more efficient than a seq
scan? (are less than 25% of the records selected) I don't know the
break-off boint in the query optimizer, but it may be more efficient on
that table to read the whole thing.
Your mouse has moved.
You must restart Windows for your changes to take effect.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2001-09-07 20:58:16|
|Subject: Re: Conditional NOTIFY is not implemented |
|Previous:||From: Bruce Momjian||Date: 2001-09-07 17:11:23|
|Subject: Re: [BUGS] pgsql/src/backend/utils/mb encnames.c|