Re: Index Using

From: Michal Hlavac <hlavki(at)medium13(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Index Using
Date: 2004-07-19 11:31:02
Message-ID: 40FBB0F6.1040100@medium13.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michal Hlavac wrote:

> my question is, why postgres doesn't use index_50 in second query???
> when I create this structure in clear db, everything is all right...
>

of course, index_50 is BTREE index with one column (i_model_id)...

thanx, hlk

--

[ miso hlavac ][ hlavki(at)medium13(dot)sk ][ http://hlavki.sk ]
[ icq:94900232 ][ callto://hlavki ]

In response to

  • Index Using at 2004-07-19 09:59:19 from Michal Hlavac

Browse pgsql-general by date

  From Date Subject
Next Message raptor@tvskat.net 2004-07-19 11:52:08 LOG table changes ...
Previous Message Michal Hlavac 2004-07-19 09:59:19 Index Using