pg_largeobject and toast

From: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi)
To: pgsql-novice(at)postgresql(dot)org
Subject: pg_largeobject and toast
Date: 2010-12-17 04:48:28
Message-ID: 20101217044828.C7A6719D539@mail.netbsd.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi,

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.

currently, the pg_largeobject table is created without a toast table
while it has a column with the EXTENDED storage parameter and
needs_toast_table() would return true for it.
so, a unrelated modification like the following will create
a toast table for it. is it considered a bug?

alter table pg_largeobject alter column data set statistics -1;

(it's convenient for me as it doesn't require allow_system_table_mods=on,
but...)

YAMAMOTO Takashi

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-12-17 15:01:57 Re: pg_largeobject and toast
Previous Message Mladen Gogala 2010-12-16 20:49:20 Pgstatindex and leaf fragmentation.