Re: Why won't it index scan?

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Why won't it index scan?
Date: 2006-05-22 20:49:02
Message-ID: 20060522204902.GS64371@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 17, 2006 at 10:29:14PM -0400, Tom Lane wrote:
> The reason the default is currently 10 is just conservatism: it was
> already an order of magnitude better than what it replaced (a *single*
> representative value) and I didn't feel I had the evidence to justify
> higher values. It's become clear that the default ought to be higher,
> but I've still got no good fix on a more reasonable default. 100 might
> be too much, or then again maybe not.
>
> I encourage you to play around with default_statistics_target and see
> what you can learn about quality of estimates vs. planning time.

Is the only downside to a large value planning speed? It seems it would
be hard to bloat that too much, except in cases where people are
striving for millisecond response times, and those folks had better know
enough about tuning to be able to adjust the stats target...

I'd wager that upping the target to 100 would eliminate a lot more
support emails than it creates.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-05-22 20:54:16 Re: Interface
Previous Message Nik 2006-05-22 20:38:20 Re: Insert into partition table hangs