Problem with index

From: eriko <eriko(at)radix(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problem with index
Date: 2001-01-25 23:59:57
Message-ID: 3A70BDFD.C1B202AF@radix.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Why ?

Thanks

Eriko

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-01-26 00:05:56 Re: timestamp calculations
Previous Message Ramiro Arenas Ramírez 2001-01-25 23:26:19 where are The logs?