Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column
Дата
Msg-id CAM3SWZTzzQmQU=a=XWiFEQyidXnSeRYEJOWf_YxWzRT04B=A-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Mon, Jun 27, 2016 at 8:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> A small-footprint answer that just occurred to me is to redefine the
> threshold as being, not NBuffers, but maintenance_work_mem.  Then a
> reasonably-sized test case could be made by reducing that to its minimum
> allowed value.  This seems like it'd be fairly unsurprising for users
> since there's lots of precedent for maintenance_work_mem affecting the
> behavior of CREATE INDEX.

I like this idea. Should I write a patch?

--
Peter Geoghegan

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #14210: filter by "=" constraint doesn't work when hash index is present on a column
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13907: Restore materialized view throw permission denied