Re: Buffer Requests Trace

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Lucas Lersch <lucaslersch(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Buffer Requests Trace
Date: 2014-10-15 13:50:21
Message-ID: 20141015135021.GH28859@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Lucas Lersch (lucaslersch(at)gmail(dot)com) wrote:
> So is it a possible normal behavior that running tpcc for 10min only access
> 50% of the database? Furthermore, is there a guideline of parameters for
> tpcc (# of warehouses, execution time, operations weight)?

Depends- you may be aware that we support index-only scans in certain
situations. This means that only the index page for a given relation
(and the visibility map) are accessed, and the heap is not.

Thanks,

Stephen

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kouhei Kaigai 2014-10-15 13:58:02 Re: How to make ResourceOwnerForgetBuffer() O(1), instead of O(N^2) scale
Previous Message Tom Lane 2014-10-15 13:50:16 Re: Proposal for better support of time-varying timezone abbreviations