Skip site navigation (1) Skip section navigation (2)

Re: Better default_statistics_target

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Better default_statistics_target
Date: 2007-11-14 05:00:06
Message-ID: 13872.1195016406@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Greg Sabino Mullane <greg(at)turnstep(dot)com> writes:
> Per a recent bug in which the planner can behave very differently at <
> 100, and accounting for the fact that analyze is still plenty fast on
> today's systems even at a tenfold increase, attached is a patch to
> change default_statistics_target from 10 to 100.

This is not happening without a whole lot more evidence (as in, more
than zero) to back up the choice of value.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-11-14 05:37:26
Subject: Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Previous:From: Webb SpragueDate: 2007-11-14 04:47:26
Subject: Re: Simplifying Text Search

pgsql-patches by date

Next:From: ITAGAKI TakahiroDate: 2007-11-14 05:26:12
Subject: Miscalculation in IsCheckpointOnSchedule()
Previous:From: Greg Sabino MullaneDate: 2007-11-14 04:38:08
Subject: Better default_statistics_target

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group