Re: Default Stats Revisited - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Default Stats Revisited
Date
Msg-id 200403111117.07988.josh@agliodbs.com
Whole thread Raw
In response to Re: Default Stats Revisited  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Default Stats Revisited  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Tom,

> Maybe you should ask on -admin or -general.  Personally I thought there
> wasn't anything to say until someone did some experiments to show
> whether an indexed-column differential is really worthwhile and what a
> plausible default value would be.  The idea sounds good in the abstract,
> but will it really help or just be another useless setting?

Yeah, that's our next step, a test.

On Monday,  I hope to have comparative stats for a difficult database on the 3 
solutions (leaving things as-is, raising the general default stats, and doing 
index_stats).

-- 
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default Stats Revisited
Next
From: Neil Conway
Date:
Subject: Re: unsafe floats