Re: Performance - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Performance
Date
Msg-id BANLkTinJqXqErAtQg--1MOaw2LJNFZmwOg@mail.gmail.com
Whole thread Raw
In response to Re: Performance  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Performance
Re: Performance
List pgsql-performance
On Wed, Apr 13, 2011 at 4:32 PM, Kevin Grittner
<Kevin.Grittner@wicourts.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?

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: how explain works to Mr Nathan Boley
Next
From: Claudio Freire
Date:
Subject: Re: Slow query postgres 8.3