Re: the number of pending entries in GIN index with FASTUPDATE=on

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: the number of pending entries in GIN index with FASTUPDATE=on
Дата
Msg-id CAHGQGwHqWG4Qu-UAZG5cYGXF0WB8e9yQBk9ThezR1YwCNPoCOA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: the number of pending entries in GIN index with FASTUPDATE=on  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: the number of pending entries in GIN index with FASTUPDATE=on  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Список pgsql-hackers
On Wed, Nov 7, 2012 at 4:34 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Nov 6, 2012 at 1:01 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Robert Haas <robertmhaas@gmail.com> writes:
>>> On Fri, Nov 2, 2012 at 12:48 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
>>>> Is there the way to know the number of pending entries in GIN index which
>>>> was created with FASTUPDATE = on? If not, is it worth implementing the
>>>> function returning that number?
>>
>>> Seems useful to me.
>>
>> Seems like the appropriate place to expose this would be in a
>> GIN-specific variant of contrib/pgstattuple's pgstatindex().
>
> Yeah, that seems good to me, too.  Or something in pgstatindex, anyway.

Agreed. Attached patch introduces the pgstatginindex() which now reports
GIN version number, number of pages in the pending list and number of
tuples in the pending list, as information about a GIN index.

Regards,

--
Fujii Masao

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Doc patch, distinguish sections with an empty row in error code table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Deferrable NOT NULL constraints in 9.3?