Postgres Pro
Downloads
Home   >   mailing lists

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

From Fujii Masao
Subject the number of pending entries in GIN index with FASTUPDATE=on
Date
Msg-id CAHGQGwEvX=iK210jpTjZEXeWgTFR6k3NmmMoezAByTLbAZ6eqg@mail.gmail.com
Whole thread Raw
Responses Re: the number of pending entries in GIN index with FASTUPDATE=on  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
Hi,

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.

Regards,

-- 
Fujii Masao

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Synchronous commit not... synchronous?
Next
From: Alexander Korotkov
Date:
Subject: Re: Incorrect behaviour when using a GiST index on points