Re: I could not get postgres to utilizy indexes

From: "gnari" <gnari(at)simnet(dot)is>
To: "Thomas Swan" <tswan(at)idigx(dot)com>, "Igor Artimenko" <iartimenko(at)bluecatnetworks(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: I could not get postgres to utilizy indexes
Date: 2004-08-18 17:26:52
Message-ID: 00e801c48548$8d2c0b70$0100000a@wp2000
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Thomas Swan" <tswan(at)idigx(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message gnari 2004-08-18 17:31:24 Re: I could not get postgres to utilizy indexes
Previous Message Thomas Swan 2004-08-18 17:12:26 Re: I could not get postgres to utilizy indexes