Re: No longer possible to query catalogs for index capabilities?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: No longer possible to query catalogs for index capabilities?
Дата
Msg-id CACjxUsM0xQ2A7dtH3jAp2sD1qYWvTPPAJLfNF3kYQ9i-bznF0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: No longer possible to query catalogs for index capabilities?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: No longer possible to query catalogs for index capabilities?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Aug 10, 2016 at 12:31 PM, Andrew Gierth
<andrew@tao11.riddles.org.uk> wrote:

> These could be limited to being testable only on a specified index, and
> not AM-wide:

>   predicate_locks (? maybe)

That one seems like it should either be at the AM level or not
included at all.  Where it would be interesting to know is if you
are a hacker looking for an AM to enhance with support, or (when
there is more than just btree supported, so it is not so easy to
remember) if you are a DBA investigating a high rate of
serialization failures and want to know whether indexes of a
certain type have index-relation predicate locking granularity or
something more fine-grained.  The latter use case seems plausible
once there is more of a mix of support among the AMs.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: No longer possible to query catalogs for index capabilities?
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Heap WARM Tuples - Design Draft