Thread: Toast question

I noticed that toast tables seem to accumulate in my database, even if
they're empty. Is there a way to get postgresql to remove (or not
create) unused toast tables?

--
Taral <taral@taral.net>
(This message is digitally signed. Please encrypt mail if possible.)
"Any technology, no matter how primitive, is magic to those who don't
understand it." -- Florence Ambrose

Taral wrote:
> I noticed that toast tables seem to accumulate in my database, even if
> they're empty. Is there a way to get postgresql to remove (or not
> create) unused toast tables?

    What  do  you  mean with "accumulate"? They (and their index)
    should exist exactly as long as the table they belong to.

    The system creates a  toast  table  automatically  for  every
    table,  where  toasted  values  could  possibly  occur in the
    future (means any table using any of the variable sized  base
    data  types).  The  only  chance you have for now would be to
    disable the toast feature in the pg_type  entries  for  those
    datatypes you use before creating your user tables.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com