From: | JanWieck(at)t-online(dot)de (Jan Wieck) |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: update on TOAST status' |
Date: | 2000-07-06 21:21:59 |
Message-ID: | 200007062121.XAA19836@hot.jw.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-07-06 21:35:13 | Re: PostgreSQL 7.1 |
Previous Message | The Hermit Hacker | 2000-07-06 21:13:31 | Re: Article on MySQL vs. Postgres |