| From: | Kevin Grittner <kgrittn(at)gmail(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: No longer possible to query catalogs for index capabilities? |
| Date: | 2016-08-10 17:40:09 |
| Message-ID: | CACjxUsM0xQ2A7dtH3jAp2sD1qYWvTPPAJLfNF3kYQ9i-bznF0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Aug 10, 2016 at 12:31 PM, Andrew Gierth
<andrew(at)tao11(dot)riddles(dot)org(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Freire | 2016-08-10 17:48:15 | Re: Heap WARM Tuples - Design Draft |
| Previous Message | Andrew Gierth | 2016-08-10 17:31:53 | Re: No longer possible to query catalogs for index capabilities? |