Re: update on TOAST status' - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: update on TOAST status'
Date
Msg-id 200007062029.QAA11590@candle.pha.pa.us
Whole thread Raw
In response to update on TOAST status  (JanWieck@t-online.de (Jan Wieck))
Responses Re: update on TOAST status'  (JanWieck@t-online.de (Jan Wieck))
Re: update on TOAST status'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>     -   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.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: Fix for pg_dump
Next
From: Bruce Momjian
Date:
Subject: Re: 2nd update on TOAST