Re: Performance

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Ogden <lists(at)darkstatic(dot)com>, Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance
Date: 2011-04-13 21:17:18
Message-ID: BANLkTinJqXqErAtQg--1MOaw2LJNFZmwOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Apr 13, 2011 at 4:32 PM, Kevin Grittner
<Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> If you model the costing to reflect the reality on your server, good
> plans will be chosen.

Wouldn't it be "better" to derive those costs from actual performance
data measured at runtime?

Say, pg could measure random/seq page cost, *per tablespace* even.

Has that been tried?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2011-04-13 21:37:41 Re: Slow query postgres 8.3
Previous Message Tomas Vondra 2011-04-13 20:19:10 Re: how explain works to Mr Nathan Boley