Re: More buffers used than a relation's relpages - Mailing list pgsql-general

From Amit Langote
Subject Re: More buffers used than a relation's relpages
Date
Msg-id CA+HiwqGUE6NF0iqKJjjE9OtP2sYOfgwqUcEpPzgKZnr9Jv2DFg@mail.gmail.com
Whole thread Raw
In response to Re: More buffers used than a relation's relpages  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
On Tue, Jun 4, 2013 at 12:17 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Monday, June 3, 2013, Amit Langote wrote:
>>
>> Hello,
>>
>> In what cases can a relation use more buffers (in shared memory) than
>> its pg_class.relpages?
>
>
> I think relpages only counts pages in the main fork, while the buffer cache
> will also have buffers for the other forks (visibility map, free space map).
> Also, relpages can be out of date if the table has grown since the last
> vac/analyze.
>

Is there a way to refer to pages of these other forks like
pg_class.relpages is for referring to relation's disk pages as of the
last analyze (is that right?)


--
Amit Langote


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: More buffers used than a relation's relpages
Next
From: Melvin Call
Date:
Subject: Re: Passing a WHERE clause by trigger to a function