Re: Indexes not working (bug in 7.0.2?)

From: Alfred Perlstein <bright(at)wintelcom(dot)net>
To: Zlatko Calusic <zlatko(at)iskon(dot)hr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexes not working (bug in 7.0.2?)
Date: 2000-09-03 21:08:27
Message-ID: 20000903140826.E18862@fw.wintelcom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Zlatko Calusic <zlatko(at)iskon(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Blakeley 2000-09-03 21:16:17 plperl crashing backend
Previous Message Zlatko Calusic 2000-09-03 14:10:17 Indexes not working (bug in 7.0.2?)