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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
