how to completely disable toasted table in postgresql and best practices to follow
Dear admin,
please help me i want to completely disable Toasted tables in postgresql as per your suggestion i have used 9.0.13 but still toasted tables are getting created.
also i want to know best practices and methods to clear such issues.
kindly help
Thanks & Regards, Zahid Quadri Database Adm inistrator
Import Notes
Reply to msg id not found: cfe428fc-79e7-4b28-9360-af728569ae7e@mail.cloverinfotech.com
On 2013-04-05 18:32:47 +0530, Zahid Quadri wrote:
Dear admin,
please help me i want to completely disable Toasted tables in postgresql as per your suggestion i have used 9.0.13 but still toasted tables are getting created.
also i want to know best practices and methods to clear such issues.
Why do you want to do that?
It is not possible to completely disable the usage of toast tables, but
maybe explaining the real reason of you wanting that helps us to give
you another solution.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 5 April 2013 15:49, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-04-05 18:32:47 +0530, Zahid Quadri wrote:
Dear admin,
please help me i want to completely disable Toasted tables in postgresql
as per your suggestion i have used 9.0.13 but still toasted tables are
getting created.also i want to know best practices and methods to clear such issues.
Why do you want to do that?
It is not possible to completely disable the usage of toast tables, but
maybe explaining the real reason of you wanting that helps us to give
you another solution.
Even if I set storage to plain for all the columns? Will then toast be used
for something else?
regards
Szymon
According to doc, YES.
http://www.postgresql.org/docs/9.2/static/storage-toast.html
MAIN allows compression but not out-of-line storage. (Actually, out-of-line
storage will still be performed for such columns, but only as a last resort
when there is no other way to make the row small enough to fit on a page.)
On Fri, Apr 5, 2013 at 9:53 AM, Szymon Guz <mabewlun@gmail.com> wrote:
Show quoted text
On 5 April 2013 15:49, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-04-05 18:32:47 +0530, Zahid Quadri wrote:
Dear admin,
please help me i want to completely disable Toasted tables in
postgresql as per your suggestion i have used 9.0.13 but still toasted
tables are getting created.also i want to know best practices and methods to clear such issues.
Why do you want to do that?
It is not possible to completely disable the usage of toast tables, but
maybe explaining the real reason of you wanting that helps us to give
you another solution.Even if I set storage to plain for all the columns? Will then toast be
used for something else?regards
Szymon
On 2013-04-05 15:53:40 +0200, Szymon Guz wrote:
On 5 April 2013 15:49, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-04-05 18:32:47 +0530, Zahid Quadri wrote:
Dear admin,
please help me i want to completely disable Toasted tables in postgresql
as per your suggestion i have used 9.0.13 but still toasted tables are
getting created.also i want to know best practices and methods to clear such issues.
Why do you want to do that?
It is not possible to completely disable the usage of toast tables, but
maybe explaining the real reason of you wanting that helps us to give
you another solution.Even if I set storage to plain for all the columns? Will then toast be used
for something else?
No, if you set it to plain it won't be stored externally. But setting to
plain actually increases the size of data (no short varlenas anymore),
so its not really a sensible choice imo. It also doesn't prevent
creation of a toast table - it just won't get used.
If you only create columns that are too short for toast (like
varchar(12) or so), the toast table won't get created.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general