Re: update on TOAST status'

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 #