pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Fabrício dos Anjos Silva <fabricio.silva@linkcom.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: How does PG know if data is in memory?
Date: Sun, 03 Oct 2010 23:34:06 -0400
Message-ID: <4CA94B2E.3080506@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTinrYVcG-K7wZ+mgGDM6x179eak24dFL8Pc3j34z@mail.gmail.com>
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>

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




view thread (31+ messages)  latest in thread

Message-ID: <4CA94B2E.3080506@2ndquadrant.com>
Permalink:  ../4CA94B2E.3080506@2ndquadrant.com/
Also on:    postgresql.org/message-id/4CA94B2E.3080506@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: greg@2ndquadrant.com, fabricio.silva@linkcom.com.br
  Subject: Re: How does PG know if data is in memory?
  In-Reply-To: <4CA94B2E.3080506@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox