> yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi) writes:
>> what's a supposed way for a user to create a toast table?
>> the comment in include/storage/large_object.h
>> ("unless the user creates a toast-table for pg_largeobject...")
>> made me think there's a way, but i couldn't find one.
> At one time there was an actual command ALTER TABLE foo CREATE TOAST TABLE
> (or something close to that, don't recall the exact spelling) that
> in principle could have been invoked on pg_largeobject. That's not
> there anymore, but as you say it's still possible for pg_largeobject
> to acquire a toast table if you're willing to perform random ALTERs
> on it. It's not recommended of course; given the usage of the table,
> it could only be a performance loss.
thanks for explanation.
is it too complicated to make the database bootstrap process perform
SET STORAGE equivalent so that random ALTERs on the table doesn't
trigger toast creation?
> regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-12-22 15:12:31|
|Subject: Re: pg_largeobject and toast |
|Previous:||From: Lukasz Brodziak||Date: 2010-12-21 12:22:49|
|Subject: Re: Problem with select statement for duplicate data|