Horton

Re: update on TOAST status'

Philip Warner <pjw@rhyme.com.au>

View thread
From: Philip Warner <pjw@rhyme.com.au>
To: Jan Wieck <JanWieck@Yahoo.com>, PostgreSQL HACKERS <pgsql-hackers@postgresql.org>
Date: 2000-07-11T13:27:32Z
Lists: pgsql-hackers 
At 15:08 11/07/00 +0200, Jan Wieck wrote:
>
>    The  atttypmod  field  on NUMERIC columns for example doesn't
>    tell the easy way how big the internal  representation  might
>    grow.  And  what  about variable size user defined types that
>    are marked toastable?  Can you estimate the maximum  internal
>    storage size for them?
>

Well, uncompressed size would be a good upper estimate, since you may be
passed already compressed data...



----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|
                                 |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/