Re: TOAST (was: BLOB) - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: TOAST (was: BLOB)
Date
Msg-id Pine.LNX.4.21.0004211954070.351-100000@localhost.localdomain
Whole thread Raw
In response to TOAST (was: BLOB)  (wieck@debis.com (Jan Wieck))
Responses Re: TOAST (was: BLOB)
Re: TOAST (was: BLOB)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: RE: VB (Virus Builder) Virus Posted
Next
From: Peter Eisentraut
Date:
Subject: Re: Counting distinct names