Sorry, I do not understand the question. But I forgot to give an additional information: I am printing the page id for the trace file in ReleaseBuffer() only if it is a shared buffer, I am not considering local buffers. I assumed that local buffers were used only for temporary tables.
On Tue, Oct 14, 2014 at 6:25 PM, Stephen Frost <sfr...@snowman.net> wrote: > * Lucas Lersch (lucasler...@gmail.com) wrote: > > Unfortunately, in the generated trace with over 2 million buffer > requests, > > only ~14k different pages are being accessed, out of the 800k of the > whole > > database. Am I missing something here? > > What do you have shared_buffers set to..? > > Thanks, > > Stephen > -- Lucas Lersch