On Wed, Nov 7, 2012 at 4:34 AM, Robert Haas <[email protected]> wrote: > On Tue, Nov 6, 2012 at 1:01 PM, Tom Lane <[email protected]> wrote: >> Robert Haas <[email protected]> writes: >>> On Fri, Nov 2, 2012 at 12:48 PM, Fujii Masao <[email protected]> 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
pgstatginindex_v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
