Re: More thoughts about planner's cost estimates
From:
"Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
To:
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: More thoughts about planner's cost estimates
Date:
2006-06-02 22:24:33
Message-ID:
4480BAA1.9040907@blackducksoftware.com (view raw or flat )
Thread:
2006-05-31 19:45:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-01 17:28:09 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-01 18:25:56 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-01 18:32:21 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-01 19:14:17 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-01 20:50:26 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-01 21:33:09 from Kenneth Marshall <ktm(at)it(dot)is(dot)rice(dot)edu>
2006-06-01 21:45:40 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-02 00:36:16 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-02 01:04:12 from David Fetter <david(at)fetter(dot)org>
2006-06-02 17:08:13 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-02 19:23:34 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-02 20:23:14 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-02 20:39:32 from Michael Dean <mdean(at)sourceview(dot)com>
2006-06-02 20:56:11 from David Fetter <david(at)fetter(dot)org>
2006-06-02 20:43:36 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-02 21:41:07 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-02 22:15:43 from Josh Berkus <josh(at)agliodbs(dot)com>
2006-06-02 22:24:33 from "Todd A(dot) Cook" <tcook(at)blackducksoftware(dot)com>
2006-06-03 15:43:39 from Jim Nasby <jnasby(at)pervasive(dot)com>
2006-06-03 18:46:07 from Hannu Krosing <hannu(at)skype(dot)net>
2006-06-04 21:34:47 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-04 22:09:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-05 09:28:08 from Hannu Krosing <hannu(at)skype(dot)net>
2006-06-05 13:29:56 from Jim Nasby <jnasby(at)pervasive(dot)com>
2006-06-02 22:59:18 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-03 19:18:14 from Hannu Krosing <hannu(at)skype(dot)net>
2006-06-03 21:38:35 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-04 06:38:25 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-04 07:09:30 from Greg Stark <gsstark(at)mit(dot)edu>
2006-06-01 23:09:48 from "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
2006-06-01 19:15:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-01 23:22:12 from "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
2006-06-01 23:43:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-02 09:01:30 from Nicolai Petri <nicolai(at)catpipe(dot)net>
2006-06-02 01:41:11 from Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
2006-06-02 02:32:10 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-02 22:36:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-02 23:05:15 from Rod Taylor <pg(at)rbt(dot)ca>
2006-06-02 23:38:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2006-06-03 19:15:31 from Mike Benoit <ipso(at)snappymail(dot)ca>
2006-06-07 00:32:03 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Lists:
pgsql-hackers
Josh Berkus wrote:
> Greg, Tom,
>
>> But for most users analyze doesn't really have to run as often as
>> vacuum. One sequential scan per night doesn't seem like that big a deal
>> to me.
>
> Clearly you don't have any 0.5 TB databases.
Perhaps something like "ANALYZE FULL"? Then only those who need the
more precise statistics would pay the cost for a full scan.
-- todd
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2006-06-02 22:36:40Subject : Re: More thoughts about planner's cost estimates Previous :From : Josh BerkusDate : 2006-06-02 22:15:43Subject : Re: More thoughts about planner's cost estimates
