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

Better default_statistics_target

From: Greg Sabino Mullane <greg(at)turnstep(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Better default_statistics_target
Date: 2007-11-14 04:38:08
Message-ID: 1195015088.24501.58.camel@greg-laptop (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.


Attachment: better_default_stats.patch
Description: text/x-patch (3.7 KB)

Responses

pgsql-hackers by date

Next:From: Webb SpragueDate: 2007-11-14 04:47:26
Subject: Re: Simplifying Text Search
Previous:From: Tom LaneDate: 2007-11-14 03:50:41
Subject: Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords

pgsql-patches by date

Next:From: Tom LaneDate: 2007-11-14 05:00:06
Subject: Re: Better default_statistics_target
Previous:From: Tom LaneDate: 2007-11-14 03:50:41
Subject: Re: a tsearch2 (8.2.4) dictionary that only filters out stopwords

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