Postgres Pro
Downloads
Home   >   mailing lists

Re: SUBSTRING performance for large BYTEA - Mailing list pgsql-general

From Tom Lane
Subject Re: SUBSTRING performance for large BYTEA
Date
Msg-id 15222.1187455749@sss.pgh.pa.us
Whole thread Raw
In response to Re: SUBSTRING performance for large BYTEA  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: SUBSTRING performance for large BYTEA  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: SUBSTRING performance for large BYTEA  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Should we consider setting storage external by default for the type?

No.  That would be counterproductive for the more typical case of bytea
values in the range of some-small-number-of-kilobytes.  Or at least
I think that's more typical than values that are so large you have to go
out of your way to fetch them in chunks.

            regards, tom lane

pgsql-general by date:

Previous
From: Ron Mayer
Date:
Subject: Re: language interface in postgresql
Next
From: Shane Ambler
Date:
Subject: Re: Blobs in Postgresql