From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 17:02:03 |
Message-ID: | 46C7260B.6060409@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Tom Lane wrote:
> "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.
The typical case that I run into with Bytea is storing enough
information to where this would be useful. Specifically items such as
pdf and .doc.
Sincerely,
Joshua D. Drake
>
> regards, tom lane
>
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGxyYLATb/zqfZUUQRAq5gAJsGFIHglJGcGjqjNc92G6Wt2U+cwQCghGMV
181pA78JUFIfpepzXLY1eK0=
=GJGH
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2007-08-18 17:11:19 | Re: SUBSTRING performance for large BYTEA |
Previous Message | Shane Ambler | 2007-08-18 16:55:59 | Re: Blobs in Postgresql |