Re: [HACKERS] Buffer Requests Trace

2014-10-16 Thread Lucas Lersch
, I think that the execution time of the benchmark is irrelevant, assuming that the transactions follow a normal distribution regarding accesses to warehouses. On Wed, Oct 15, 2014 at 7:41 PM, Jeff Janes wrote: > On Wed, Oct 15, 2014 at 6:22 AM, Lucas Lersch > wrote: > >> So i

Re: [HACKERS] Buffer Requests Trace

2014-10-15 Thread Lucas Lersch
: > * Lucas Lersch (lucasler...@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)? > >

Re: [HACKERS] Buffer Requests Trace

2014-10-15 Thread Lucas Lersch
possible as a way to improve txn rates. > > Check that you're touching all tables. > > -- > Simon Riggs http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services > -- Lucas Lersch

Re: [HACKERS] Buffer Requests Trace

2014-10-15 Thread Lucas Lersch
I am recording the BufferDesc.tag.blockNum for the buffer along with the spcNode, dbNode, relNode, also present in the tag. On Wed, Oct 15, 2014 at 2:27 PM, Simon Riggs wrote: > On 15 October 2014 12:49, Lucas Lersch wrote: > > Sorry for taking so long to answer. I am sending att

Re: [HACKERS] Buffer Requests Trace

2014-10-15 Thread Lucas Lersch
, Simon Riggs wrote: > On 14 October 2014 17:08, Lucas Lersch 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 h

Re: [HACKERS] Buffer Requests Trace

2014-10-14 Thread Lucas Lersch
; into the shared_buffers. On Tue, Oct 14, 2014 at 7:21 PM, Stephen Frost wrote: > * Lucas Lersch (lucasler...@gmail.com) wrote: > > Aren't heap and index requests supposed to go through the shared buffers > > anyway? > > Sure they do, but a given page in shared_buffers c

Re: [HACKERS] Buffer Requests Trace

2014-10-14 Thread Lucas Lersch
Aren't heap and index requests supposed to go through the shared buffers anyway? On Tue, Oct 14, 2014 at 7:02 PM, Stephen Frost wrote: > * Lucas Lersch (lucasler...@gmail.com) wrote: > > shared_buffers is 128MB and the version of pgsql is 9.3.5 > > I suspect you're no

Re: [HACKERS] Buffer Requests Trace

2014-10-14 Thread Lucas Lersch
shared_buffers is 128MB and the version of pgsql is 9.3.5 On Tue, Oct 14, 2014 at 6:31 PM, Lucas Lersch 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

Re: [HACKERS] Buffer Requests Trace

2014-10-14 Thread Lucas Lersch
, Oct 14, 2014 at 6:25 PM, Stephen Frost 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.

[HACKERS] Buffer Requests Trace

2014-10-14 Thread Lucas Lersch
something here? Best regards. -- Lucas Lersch