| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Default Stats Revisited |
| Date: | 2004-03-11 18:06:40 |
| Message-ID: | Pine.LNX.4.33.0403111105460.14517-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 11 Mar 2004, Josh Berkus wrote:
> Scott,
>
> > I like it. Would a multiplier be acceptable?
> > default_stats_index_multiplier = 10
>
> Yeah, I thought about that, but a multiplier would be harder to manage for
> most people. I mean, what if your default_stats are at 25 and you want
> your index_stats at 40? PITA. Also, if you wanted to increase the default
> stats but *forgot* that the index_stats were a multiplier ...
>
> I think a straight number is less confusing.
But possible more error prone. If you crank up the default statistics to
50, but the index default is still 25... OTOH, you could always have the
setting of used for index default be whichever is greater... hmmm.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Smith | 2004-03-11 18:23:48 | creating index on changed field type |
| Previous Message | Tom Lane | 2004-03-11 18:05:36 | Re: client side syntax error localisation for psql (v1) |