Re: Problem with index

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: eriko <eriko(at)radix(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problem with index
Date: 2001-01-25 20:39:32
Message-ID: Pine.BSF.4.21.0101251238070.86017-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jie Liang 2001-01-25 22:54:08 Re: pg_shadow problem
Previous Message lbottorff 2001-01-25 19:00:46 pg_shadow problem