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

From Philip Warner
Subject Re: update on TOAST status'
Date
Msg-id 3.0.5.32.20000711232732.02881100@mail.rhyme.com.au
Whole thread Raw
In response to Re: update on TOAST status'  (JanWieck@t-online.de (Jan Wieck))
List 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   |/


pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: postgres 7.2 features.
Next
From: Oliver Teuber
Date:
Subject: mailing list archive dead again!