Bruce Momjian wrote:
> > - VACUUM doesn't propagate ANALYZE to TOAST tables.
> > Statistics for them are needless because the toast access
> > is allways hardcoded indexed.
>
> I don't think statistics are insignificant for TOASTed columns. If I
> say col=3, the optimizer uses that information for estimating the number
> of rows returned, and figuring out the type of join and order of join to
> perform, not just for "use index, don't use index" decisions.
Ask your boys to give you a training session for "reading" when they go to bed tonight - and greet them from
the"police officer" :-)
I said "to TOAST tables", not "TOASTed columns".
Their master tables will allways have the statistics, including those for toasted columns, if you ask for
them via ANALYZE.
In normal operation, noone would ever know if a TOAST table is accessed during his query - not even the
planner or optimmizer. It's totally transparent and the only one accessing the TOAST tables is the toaster
himself - and he knows what he does.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #