Re: Indexes not working (bug in 7.0.2?) - Mailing list pgsql-general

From Alfred Perlstein
Subject Re: Indexes not working (bug in 7.0.2?)
Date
Msg-id 20000903140826.E18862@fw.wintelcom.net
Whole thread Raw
In response to Indexes not working (bug in 7.0.2?)  (Zlatko Calusic <zlatko@iskon.hr>)
List pgsql-general
* Zlatko Calusic <zlatko@iskon.hr> [000903 07:59] wrote:
> Hi!
>
> This is my first post (not counting those failed because I posted them
> from the other email address) so please be gentle.
>
> I have recently started playing with PostgreSQL and found what I think
> is a bug in postgres. I'm using 7.0.2 from Debian Linux package
> (woody) if its of any difference.
>
> I have a table like this:

[snip]

Two things:

Try "vacuum analyze subscriber;"
if that doesn't work you may want to try
"set enable seqscan off;"

-Alfred

pgsql-general by date:

Previous
From: Zlatko Calusic
Date:
Subject: Indexes not working (bug in 7.0.2?)
Next
From: Michael Blakeley
Date:
Subject: plperl crashing backend