Re: Index Using - Mailing list pgsql-general

From Michal Hlavac
Subject Re: Index Using
Date
Msg-id 40FBB0F6.1040100@medium13.sk
Whole thread Raw
In response to Index Using  (Michal Hlavac <hlavki@medium13.sk>)
List 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@medium13.sk ][ http://hlavki.sk ]
[ icq:94900232 ][ callto://hlavki ]

pgsql-general by date:

Previous
From: Michal Hlavac
Date:
Subject: Index Using
Next
From: "raptor@tvskat.net"
Date:
Subject: LOG table changes ...