Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?

From: Greg Stark <stark(at)enterprisedb(dot)com>
To: Shadar <shauldar(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
Date: 2009-06-11 15:08:44
Message-ID: 4136ffa0906110808y4bfafa8bj194a4315b3e8e02d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 11, 2009 at 4:03 PM, Shadar<shauldar(at)gmail(dot)com> wrote:
>
>>>- I don't believe we have any record over 8K. So the 2nd method is best?
>
> When should I drop the TOAST table, before or after my DB is populated? I.e.
> Postgres will then move the TOASTED data inside my table?

No it won't. Any data in the toast table will be lost and you'll get
errors if you try to access it.

Incidentally please don't quote back the whole message, just quote the
parts you're responding to. Thanks.

--
Gregory Stark
http://mit.edu/~gsstark/resume.pdf

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-06-11 15:10:17 Re: pgindent run coming
Previous Message Tom Lane 2009-06-11 15:05:38 Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?