Re: Buffer Requests Trace

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Lucas Lersch <lucaslersch(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Buffer Requests Trace
Date: 2014-10-15 07:49:57
Message-ID: CA+U5nMJ6=YzqHvUO6+C2KKErnO-QvhtamfsOtOj=HvFZSawx_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 14 October 2014 17:08, Lucas Lersch <lucaslersch(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Atri Sharma 2014-10-15 08:02:56 Support UPDATE table SET(*)=...
Previous Message Amit Kapila 2014-10-15 07:47:48 Re: Scaling shared buffer eviction