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
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 |