Re: Buffer Requests Trace - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Buffer Requests Trace
Date
Msg-id CA+U5nMJ6=YzqHvUO6+C2KKErnO-QvhtamfsOtOj=HvFZSawx_A@mail.gmail.com
Whole thread Raw
In response to Buffer Requests Trace  (Lucas Lersch <lucaslersch@gmail.com>)
Responses Re: Buffer Requests Trace
List pgsql-hackers
On 14 October 2014 17:08, Lucas Lersch <lucaslersch@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?

We can't tell what you're doing just by knowing the number of unique
items in your list.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Scaling shared buffer eviction
Next
From: Atri Sharma
Date:
Subject: Support UPDATE table SET(*)=...