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

help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Claudio Freire <klaussfreire@gmail.com>
To: Nathan Boley <npboley@gmail.com>
Cc: Ogden <lists@darkstatic.com>
Cc: Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance
Date: Wed, 13 Apr 2011 17:15:31 -0500
Message-ID: <4DA5DA33020000250003C7CC@gw.wicourts.gov> (raw)
In-Reply-To: <BANLkTimyWkoX8Dj=4CKAjhY82ibru-An7g@mail.gmail.com>
References: <DF2D5436-117C-4D02-9B3C-A55723B7DDE1@darkstatic.com>
	<20110412171855.GA14292@tux>
	<FC3A3A2B-3ECB-41BA-8F94-356D6FED3695@darkstatic.com>
	<4DA496FA.3070908@fuzzy.cz>
	<8F22D592-23C1-4A3C-94A5-48363332ADD3@darkstatic.com>
	<4DA4BFA2.5060601@fuzzy.cz>
	<B93DFBBB-DA56-4044-A508-0B7E4A2CFD28@darkstatic.com>
	<4DA4D40A.4010200@fuzzy.cz>
	<A0B9339E-9D58-4842-A206-050B773360B6@darkstatic.com>
	<4DA56DA8020000250003C783@gw.wicourts.gov>
	<BANLkTinJqXqErAtQg--1MOaw2LJNFZmwOg@mail.gmail.com>
	<BANLkTimyWkoX8Dj=4CKAjhY82ibru-An7g@mail.gmail.com>

Nathan Boley <npboley@gmail.com> wrote:
 
> The problem is that caching effects have a large effect on the
> time it takes to access a random page, and caching effects are
> very workload dependent. So anything automated would probably need
> to optimize the parameter values over a set of 'typical' queries,
> which is exactly what a good DBA does when they set
> random_page_cost...
 
Another database product I've used has a stored procedure you can
run to turn on monitoring of workload, another to turn it off and
report on what happened during the interval.  It drags performance
enough that you don't want to leave it running except as a tuning
exercise, but it does produce very detailed statistics and actually
offers suggestions on what you might try tuning to improve
performance.  If someone wanted to write something to deal with this
issue, that seems like a sound overall strategy.
 
-Kevin



view thread (60+ messages)  latest in thread

Message-ID: <4DA5DA33020000250003C7CC@gw.wicourts.gov>
Permalink:  ../4DA5DA33020000250003C7CC@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4DA5DA33020000250003C7CC@gw.wicourts.gov

 · 

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: Kevin.Grittner@wicourts.gov, klaussfreire@gmail.com, npboley@gmail.com, lists@darkstatic.com, tv@fuzzy.cz
  Subject: Re: Performance
  In-Reply-To: <4DA5DA33020000250003C7CC@gw.wicourts.gov>

* 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