> While regular ANALYZE seems to be pretty good ... is it insane to
> suggest determining the min/max bounds of problem columns by looking at
> a btree index on the column in ANALYZE, instead of relying on random
> data sampling? An ANALYZE that didn't even have to scan the indexes but
> just look at the ends might be something that could be run much more
> frequently with less I/O and memory cost than a normal ANALYZE, just to
> selectively update key stats that are an issue for such continuously
> advancing columns.
... which Tom Lane already raised in a smarter way in a message I hadn't
read yet. Sorry for the noise.
In response to
pgsql-hackers by date
|Next:||From: Tatsuo Ishii||Date: 2009-12-31 06:56:11|
|Subject: Re: exec_execute_message crash |
|Previous:||From: Craig Ringer||Date: 2009-12-31 04:17:29|
|Subject: Re: Thoughts on statistics for continuously advancing