Re: Revisiting default_statistics_target

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Revisiting default_statistics_target
Date: 2009-05-22 17:39:08
Message-ID: 1243013948.16418.864.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2009-05-22 at 13:35 -0400, Stephen Frost wrote:
> Greg,

> dbt-2 is for OLTP, not for DW. Greg Smith's comment was actually that
> we shouldn't penalize the OLTP crowd (by raising the value) for the
> benefit of the DW crowd (who need it higher than 100 anyway).
>

I appear to have completely missed the top part of Greg Smith's original
email. Sorry about that Greg.

We probably need to test this to get some more data points. Of course
that is why we have the performance lab :)

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jignesh K. Shah 2009-05-22 17:46:52 Re: Revisiting default_statistics_target
Previous Message Tom Lane 2009-05-22 17:38:45 Re: Revisiting default_statistics_target