On Fri, Jul 17, 2009 at 11:10 PM, Kevin Grittner<kevin.gritt...@wicourts.gov> wrote: > Laurent Laborde <kerdez...@gmail.com> wrote: > >> What about SET STORAGE MAIN then ? To prevent out-of-line storage ? > > Well, that doesn't try as hard as you might think to keep from storing > data out-of-line. It uses the same threshold as the default EXTENDED > storage, but saves the out-of-line option for such columns as the last > thing to try to get it within the threshold. It is because I wrote a > very small patch to address that issue that I jumped in on your issue. > > If you wanted to try my patch here: > > http://archives.postgresql.org/message-id/4a3638530200002500027...@gw.wicourts.gov > > you could adjust both TOAST_TUPLES_PER_PAGE_MAIN and > TOAST_TUPLES_PER_PAGE to suit your needs and set storage for columns > to MAIN as needed. Be very cautious if you try this, because this > patch has not yet been reviewed or accepted.
I'll take a look at it, compile, and try that. (on a test server). Thank you :) -- Laurent Laborde Sysadmin @ http://www.over-blog.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
