ach alanchi...@gmail.com wrote:
One quick follow up since I'm expecting y'all might know: Do the
statistics targets actually speed performance on an index search
itself; the actual lookup? Or are the JUST to inform the planner
towards the best pathway decision?
Since the statistics are
Thanks guys! I'm gonna try tuning the statistics back down to 10 on that
table and see what that does to the insertion rates. Oh and for Mark: Not
to worry - i'd actually tuned the stats there up myself awhile ago in an
experiment to see if -that- would've sped insertions some; back before i'd
On Mon, May 13, 2013 at 6:01 PM, ach alanchi...@gmail.com wrote:
what I'm wondering is, since
the unique constraint already covers the whole table and all rows in
entirety, is it really necessary for statistics to be set that high on
those?
AFAIK if there are exact-matching unique
On 14/05/13 10:10, Marti Raudsepp wrote:
On Mon, May 13, 2013 at 6:01 PM, ach alanchi...@gmail.com wrote:
what I'm wondering is, since
the unique constraint already covers the whole table and all rows in
entirety, is it really necessary for statistics to be set that high on
those?
AFAIK if