Re: [GENERAL] [HACKERS] Avoiding io penalty when updating large objects

2005-06-28 Thread Mark Dilger
Tom Lane wrote: Alvaro Herrera <[EMAIL PROTECTED]> writes: On Tue, Jun 28, 2005 at 07:38:43PM -0700, Mark Dilger wrote: If, for a given row, the value of c is, say, approximately 2^30 bytes large, then I would expect it to be divided up into 8K chunks in an external table, and I should be ab

Re: [GENERAL] [HACKERS] Avoiding io penalty when updating large objects

2005-06-28 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Tue, Jun 28, 2005 at 07:38:43PM -0700, Mark Dilger wrote: >> If, for a given row, the value of c is, say, approximately 2^30 bytes >> large, then I would expect it to be divided up into 8K chunks in an >> external table, and I should be able to fetc

Re: [GENERAL] [HACKERS] Avoiding io penalty when updating large objects

2005-06-28 Thread Alvaro Herrera
On Tue, Jun 28, 2005 at 07:38:43PM -0700, Mark Dilger wrote: > I would like to write a postgres extension type which represents a btree of > data and allows me to access and modify elements within that logical btree. > Assume the type is named btree_extension, and I have the table: > > CREATE TA