Have you run a vacuum analyze on the table in question?
How many rows does the optimizer think the query is going to
get (from the explain output)?
On Thu, 25 Jan 2001, eriko wrote:
> Hello all, I have a problem.
>
> When a try to use EXPLAIN <select * from table where pk=value>
>
> The optimize don't user the index of primary key.