Re: TOAST (was: BLOB)

Jan Wieck writes:

>     I  just  successfully  stored the entire PG sources (~10M) in
>     one table.  Stored are all 936  .[chyl]  files.

Cool, then we can get rid of CVS. :-)

>     clob  is  a  user  defined,  very  simple varsize datatype, I
>     created for testing.

Keep it, it's SQL3.

>     Seems there's  something  wrong  in  our  deadlock  detection
>     algorithm.

Our deadlock detection "algorithm" is that when nothing happens for 1 sec
then that's a deadlock. Increasing that number might make those messages
go away but that's still far from an algorithm, of course.

>     I'll  need  alot  of  help  to  make  all  our existing types
>     toastable,

I'm wondering how transparent all of this will be. What is involved in
making existing types toastable? How does that affect user defined
datatypes now and in the future?


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden