Re: why does the toast table exist? - Mailing list pgsql-general

On Wed, Feb 16, 2011 at 02:36:03PM +0600, AI Rumman wrote:
> I have no idea why the TOAST table exists for audit_trial table.
>
>  \d audit_trial
>           Table "public.audit_trial"
>    Column   |            Type             | Modifiers
> ------------+-----------------------------+-----------
>  auditid    | integer                     | not null
>  userid     | integer                     |
>  module     | character varying(255)      |
>  action     | character varying(255)      |
>  recordid   | character varying(20)       |
>  actiondate | timestamp without time zone |

Supposing your encoding is UTF8, each character can consume up to four bytes.  A
row could use up to around 4 + 4 + 4*(255+255+20) + 8 bytes, which is large
enough to be toastable at the default block size.