Re: I could not get postgres to utilizy indexes - Mailing list pgsql-performance

From gnari
Subject Re: I could not get postgres to utilizy indexes
Date
Msg-id 00e801c48548$8d2c0b70$0100000a@wp2000
Whole thread Raw
In response to I could not get postgres to utilizy indexes  ("Igor Artimenko" <iartimenko@bluecatnetworks.com>)
List pgsql-performance
"Thomas Swan" <tswan@idigx.com> says:


> Igor Artimenko wrote:
>

[ snipped question that was almost exactly a repeat
  of one we saw yesterday ]

> >
> >
> Igor, you may want to run "vacuum analyze" and see if your results change.

Actually, I think it was determined that the problem was due to the
int index

Michal Taborsky suggested this solution:

    select id from test where id = 50000::int8

did this not help ?

gnari




pgsql-performance by date:

Previous
From: Thomas Swan
Date:
Subject: Re: I could not get postgres to utilizy indexes
Next
From: "gnari"
Date:
Subject: Re: I could not get postgres to utilizy indexes