Re: Buffer Requests Trace - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Buffer Requests Trace
Date
Msg-id 20141015135021.GH28859@tamriel.snowman.net
Whole thread Raw
In response to Re: Buffer Requests Trace  (Lucas Lersch <lucaslersch@gmail.com>)
Responses Re: Buffer Requests Trace
List pgsql-hackers
* Lucas Lersch (lucaslersch@gmail.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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: group locking: incomplete patch, just for discussion
Next
From: Tom Lane
Date:
Subject: Re: Proposal for better support of time-varying timezone abbreviations