Re: More buffers used than a relation's relpages

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: More buffers used than a relation's relpages
Date: 2013-06-04 03:27:07
Message-ID: CA+HiwqGUE6NF0iqKJjjE9OtP2sYOfgwqUcEpPzgKZnr9Jv2DFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 4, 2013 at 12:17 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 任洪彩 2013-06-04 08:44:35 How to modify dump files created by pg_dump
Previous Message Jeff Janes 2013-06-04 03:17:57 Re: More buffers used than a relation's relpages