shared_buffers is 128MB and the version of pgsql is 9.3.5 On Tue, Oct 14, 2014 at 6:31 PM, Lucas Lersch <lucasler...@gmail.com> wrote:
> 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 > -- Lucas Lersch
