Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET? - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
Date
Msg-id 4136ffa0906110808y4bfafa8bj194a4315b3e8e02d@mail.gmail.com
Whole thread Raw
In response to Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?  (Shadar <shauldar@gmail.com>)
List pgsql-hackers
On Thu, Jun 11, 2009 at 4:03 PM, Shadar<shauldar@gmail.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Modifying TOAST_TUPLE_THRESHOLD and TOAST_TUPLE_TARGET?
Next
From: Andrew Dunstan
Date:
Subject: Re: pgindent run coming