Re: [HACKERS] pageinspect: Hash index support

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: [HACKERS] pageinspect: Hash index support
Дата
Msg-id
CA+Tgmoa6cKSV26d_XMwqw2Hwh_hk5wZpuVJg18WTVQ-L6vr+Aw@mail.gmail.com
Ответ на
Список
Дерево обсуждения
pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: pageinspect: Hash index support Jeff Janes <jeff.janes@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Jeff Janes <jeff.janes@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Jeff Janes <jeff.janes@gmail.com>
Re: pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Tom Lane <tgl@sss.pgh.pa.us>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] pageinspect: Hash index support Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] pageinspect: Hash index support Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] pageinspect: Hash index support Mithun Cy <mithun.cy@enterprisedb.com>
Re: [HACKERS] pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Jeff Janes <jeff.janes@gmail.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Amit Kapila <amit.kapila16@gmail.com>
Re: pageinspect: Hash index support Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pageinspect: Hash index support Amit Kapila <amit.kapila16@gmail.com>
Re: pageinspect: Hash index support Jesper Pedersen <jesper.pedersen@redhat.com>
Re: pageinspect: Hash index support Ashutosh Sharma <ashu.coek88@gmail.com>
Re: pageinspect: Hash index support Jeff Janes <jeff.janes@gmail.com>
Re: pageinspect: Hash index support Alvaro Herrera <alvherre@2ndquadrant.com>
On Thu, Feb 2, 2017 at 6:29 AM, Ashutosh Sharma  wrote:
>>
>> +               ptr = (char *) itup + IndexInfoFindDataOffset(itup->t_info);
>> +               Assert(ptr <= uargs->page + BLCKSZ);
>>
>> I think this should be promoted to an ereport(); these functions can
>> accept an arbitrary bytea.
>
> I think we had added 'ptr' variable initially just to dump hash code
> in hexadecimal format but now since we have removed that logic from
> current code, I think it is no  more required and I have therefore
> removed it from the current patch. Below is the code that used it
> initially. It got changed as per your comment - [1]

OK.

> I think it's OK to check hash_bitmap_info() or any other functions
> with different page types at least once.
>
> [1]- https://www.postgresql.org/message-id/CA%2BTgmoZUjrVy52TUU3b_Q5L6jcrt7w5R4qFwMXdeCuKQBmYWqQ%40mail.gmail.com

Sure, I just don't know if we need to test them 4 or 5 times.  But I
think this is good enough for now - it's not like this code is written
in stone once committed.

So, committed.  Wow, I wish every patch had this many reviewers.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
От: Jesper Pedersen
Дата:
FAQ