Skip site navigation (1) Skip section navigation (2)

Re: Synchronized Scan benchmark results

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Luke Lonergan <llonergan(at)greenplum(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Synchronized Scan benchmark results
Date: 2007-04-03 16:32:57
Message-ID: 1175617977.4152.9.camel@dogma.v10.wvs (view raw or flat)
Thread:
Lists: pgsql-hackers
On Mon, 2007-04-02 at 21:38 -0700, Luke Lonergan wrote:
> Jeff,
> 
> Your conclusions sound great - can you perhaps put the timings in a column
> in your table so we can confirm them?
> 

I just threw the logs up, which contain the timings involved. I will try
to make graphs out of them, but the data is there. 

The logs contain:
* The time a given backend fetches a page, if that page is an even
multiple of 5k
* The duration of a scan
* The time the scan started
* The cache hit ratio as reported by log_executor_stats

Your right, I do need to summarize it and make it more visually
accessible. 

Regards,
	Jeff Davis


In response to

pgsql-hackers by date

Next:From: Zdenek KotalaDate: 2007-04-03 16:39:59
Subject: Re: Questions about pid file creation code
Previous:From: Peter EisentrautDate: 2007-04-03 16:10:08
Subject: Re: Implicit casts to text

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group