Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: More buffers used than a relation's relpages
Date
Msg-id CAMkU=1z6tqC+sfNwXmxR3vXZV4TaXXhnJN1aasoHgpMrUXj7gQ@mail.gmail.com
Whole thread Raw
In response to More buffers used than a relation's relpages  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: More buffers used than a relation's relpages  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-general
Tree view
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.

Cheers,

Jeff

pgsql-general by date:

Previous
From: Amit Langote
Date:
Subject: More buffers used than a relation's relpages
Next
From: Amit Langote
Date:
Subject: Re: More buffers used than a relation's relpages