Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> So how about a kind of sample scanning in a separate ANALYZE
> command ?
I do think it'd be a good idea to separate out the stats-gathering
into an ANALYZE command that can be invoked separately from VACUUM.
For one thing, there's no good reason to hold down an exclusive
lock on the target table while we are gathering stats.
But that doesn't answer the question: how can we measure the extent
to which a table is in the same order as an index? And even that
is too one-dimensional a concept to apply to r-tree indexes, for
example. What do we do for r-trees?
regards, tom lane