From: | Barry Lind <barry(at)xythos(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | How to turn off TOAST on a table/column |
Date: | 2001-11-27 20:25:04 |
Message-ID: | 3C03F6A0.1010702@xythos.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I am looking into some performance issues with an application I have. I
want to do some testing to see how much overhead TOAST adds to my
application. I have a table that performs a similar function to the
pg_largeobject table. I have noticed that pg_largeobject doesn't have
toast enabled (i.e. reltoastrelid is 0). However when I create my table
it always gets a value for reltoastrelid. Since pg_largeobject is
created without toast, I am assuming this is intentional and that for
certain classes of tables it may make sense not to toast the tuples.
Which makes sense because inserting into the toast table will involve
extra disk IOs and if the tuple would have fit into the base table these
extra IOs could be avoided.
So how do I create a table without toast enabled? I have looked through
the docs for 'create table' and didn't see anything that indicates this
is possible. Is there some undocumented syntax?
thanks,
--Barry
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-11-27 20:52:27 | Re: [HACKERS] How to turn off TOAST on a table/column |
Previous Message | Tom Lane | 2001-11-27 20:05:07 | Re: Adding a rule makes my sequence increment twice |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2001-11-27 20:48:11 | Re: Announcement: I've joined Red Hat |
Previous Message | Tom Lane | 2001-11-27 20:21:18 | Announcement: I've joined Red Hat |