Postgres Pro
Downloads
Home   >   mailing lists

Re: the number of pending entries in GIN index with FASTUPDATE=on - Mailing list pgsql-hackers

From Robert Haas
Subject Re: the number of pending entries in GIN index with FASTUPDATE=on
Date
Msg-id CA+Tgmob1SfvFd6H_Hk1YepOOsrece7Fa-KkjaWqXaRaX4stu3g@mail.gmail.com
Whole thread Raw
In response to the number of pending entries in GIN index with FASTUPDATE=on  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: the number of pending entries in GIN index with FASTUPDATE=on  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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?
>
> I sometimes would like to know that number when I measure how much
> pending entries affect the performance of GIN index scan and tune how
> frequently autovacuum should run VACUUM to clean up them.

Seems useful to me.

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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FDW for PostgreSQL
Next
From: Jeff Davis
Date:
Subject: Re: Arguments to foreign tables?