On 28.11.2012 04:11, Kyotaro HORIGUCHI wrote:
3. pgstatginidex shows only version, pending_pages, and
pendingtuples. Why don't you show the other properties such as
entry pages, data pages, entries, and total pages as
pgstatindex does?
I didn't expose those because they are accurate as
> > 1. This patch applies current git head cleanly, but installation
> > ends up with failure because of the lack of
> > pgstattuple--1.0--1.1.sql which added in Makefile.
>
> Added pgstattuple--1.0--1.1.sql.
Good. Installation completed and ALTER EXTENSION UPDATE works
with that.
> > 2. I f
On Tue, Nov 20, 2012 at 4:44 PM, Kyotaro HORIGUCHI
wrote:
> Hello,
>
>> 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.
>
> It seems fi
Hello,
> 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.
It seems fine on the whole, and I have some suggestions.
1. This patch applie
On Wed, Nov 7, 2012 at 4:34 AM, Robert Haas wrote:
> On Tue, Nov 6, 2012 at 1:01 PM, Tom Lane wrote:
>> Robert Haas writes:
>>> On Fri, Nov 2, 2012 at 12:48 PM, Fujii Masao wrote:
Is there the way to know the number of pending entries in GIN index which
was created with FASTUPDATE = o
On Tue, Nov 6, 2012 at 1:01 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Fri, Nov 2, 2012 at 12:48 PM, Fujii Masao 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 retur
Robert Haas writes:
> On Fri, Nov 2, 2012 at 12:48 PM, Fujii Masao 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 th
On Fri, Nov 2, 2012 at 12:48 PM, Fujii Masao 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 h
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 ind