Re: SUBSTRING performance for large BYTEA

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Vance Maverick <vmaverick(at)pgp(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: SUBSTRING performance for large BYTEA
Date: 2007-08-18 16:49:09
Message-ID: 15222.1187455749@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Ambler 2007-08-18 16:55:59 Re: Blobs in Postgresql
Previous Message Ron Mayer 2007-08-18 16:46:30 Re: language interface in postgresql