Message-ID: <4CA94B2E.3080506@2ndquadrant.com>
Date: Sun, 03 Oct 2010 23:34:06 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: =?ISO-8859-1?Q?Fabr=EDcio_dos_Anjos_Silva?=
 <fabricio.silva@linkcom.com.br>
CC: pgsql-performance@postgresql.org
Subject: Re: How does PG know if data is in memory?
References: <AANLkTin5G0jXUbeNdC+1s9LQpk1ZpvDuX-6n90oonen3@mail.gmail.com>
	<AANLkTik5hnOcU=spN0wmWmR6_wHN=sKfVNzJeDuPTVW_@mail.gmail.com>
	<AANLkTinrtVbjtadteR88xWGGYovAzhgOWR1=pXLDi08M@mail.gmail.com>
	<4CA5D2F5.5070900@postnewspapers.com.au>
	<4CA59FCF02000025000362AE@gw.wicourts.gov>
	<AANLkTinrYVcG-K7wZ+mgGDM6x179eak24dFL8Pc3j34z@mail.gmail.com>
In-Reply-To: <AANLkTinrYVcG-K7wZ+mgGDM6x179eak24dFL8Pc3j34z@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Fabrício dos Anjos Silva wrote:
> Is there any automated test tool? A can compile a list of real-world 
> queries, and provide an exact copy of my db server just for testing. 
> But how do I do it? Write a bunch of scripts? Is there any serious 
> tool that try different parameters, run a load test, process results 
> and generate reports?

There's a list of tools for playing back a test workload at 
http://wiki.postgresql.org/wiki/Statement_Playback

I'm not aware of anyone beyond some academic research that has taken 
that idea and built something to test many database parameter 
combinations.  They did that at 
http://www.cs.duke.edu/~shivnath/papers/ituned.pdf but I don't think 
that code went public; I asked about it at one point and never heard 
anything really useful back.

-- 
Greg Smith, 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support  www.2ndQuadrant.us
Author, "PostgreSQL 9.0 High Performance"    Pre-ordering at:
https://www.packtpub.com/postgresql-9-0-high-performance/book