Re: Partial index causing wrong results to be returned on 8.1.3

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Partial index causing wrong results to be returned on 8.1.3
Дата
Msg-id d6b3450d6b6fa3acf22e5d388a245e0c@biglumber.com
обсуждение исходный текст
Ответ на Re: Partial index causing wrong results to be returned on 8.1.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> If it gives right answers after you increase work_mem sufficiently,
> I'd bet on this one ...

That's a good bet. Changing it from 1024 to 3500 did the trick ... only
one row returned, even when using the index. Thanks very much!

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200608290100
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8


-----BEGIN PGP SIGNATURE-----

iD8DBQFE88nuvJuQZxSWSsgRAkA8AJ9xKgOcEmK4swC0Dji4WtEs4p+juwCeIHJN
xyNAvlAT5c2O6pWI0C2G03I=
=EvGR
-----END PGP SIGNATURE-----

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Partial index causing wrong results to be returned on 8.1.3
Следующее
От: Klaus Ita
Дата:
Сообщение: Re: error in upper()