Re: Indexes not working (bug in 7.0.2?)

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема Re: Indexes not working (bug in 7.0.2?)
Дата
Msg-id 20000903140826.E18862@fw.wintelcom.net
обсуждение исходный текст
Ответ на Indexes not working (bug in 7.0.2?)  (Zlatko Calusic <zlatko@iskon.hr>)
Список 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 по дате отправления:

Предыдущее
От: Zlatko Calusic
Дата:
Сообщение: Indexes not working (bug in 7.0.2?)
Следующее
От: Michael Blakeley
Дата:
Сообщение: plperl crashing backend