, 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
:
> * 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)?
>
>
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
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
, 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
;
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
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
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
, 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.
something here?
Best regards.
--
Lucas Lersch
10 matches
Mail list logo