Re: Do text columns create pg_toast tables? - Mailing list pgsql-general

From Tom Lane
Subject Re: Do text columns create pg_toast tables?
Date
Msg-id 25855.1216996667@sss.pgh.pa.us
Whole thread Raw
In response to Re: Do text columns create pg_toast tables?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> In any case, since you're not using large values, the vacuum of the
> toast table is essentially free.

Yeah.  Note the last line of the quoted log:

>> Jul 25 02:31:19 iprobe001 postgres[25488]: [5-4]        system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec

An empty toast table really isn't worth worrying about.

            regards, tom lane

pgsql-general by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Help Me !!!
Next
From: admin
Date:
Subject: Re: php + postgresql