Re: Minor inaccuracy in jsonb_path_ops documentation

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Minor inaccuracy in jsonb_path_ops documentation
Дата
Msg-id CAM3SWZSVQnieHi+56PPqGD+azt_H=9-LiFAN0txHJXGjZRLF2w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Minor inaccuracy in jsonb_path_ops documentation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Thu, Jul 24, 2014 at 3:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The fact that the planner can avoid that in the presence of a
> simple constant comparison value doesn't make it a good idea to
> use jsonb_path_ops indexes if you do this type of query a lot,
> because in some usages the planner won't see a constant comparison
> value, and if so it'll likely choose an indexscan by default.

Well, with idiomatic usage a constant value generally will be used.
But I do see your point.

-- 
Peter Geoghegan



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Why does xlog.c not treat COMMIT_PREPARED/ABORT_PREPARED as commit/abort?
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: SKIP LOCKED DATA (work in progress)