| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Hunter, Ray" <rhunter(at)enterasys(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Large Objects |
| Date: | 2002-02-28 01:05:52 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOGEJDCBAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Large ObjectsDon't use them. They were needed when Postgres only supported
8k per row. Now you can just use the 'text' datatype for text data and the
'bytea' datatype for binary data. You have a limit of a few gigs per row
with them.
Chris
-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Hunter, Ray
Sent: Wednesday, 27 February 2002 9:46 PM
To: pgsql-sql(at)postgresql(dot)org
Subject: [SQL] Large Objects
I have been reading the user manual for largre objects in postgres. What
I do not understand is when and why you would use them?
Can someone point me to some good documentation on this...
Thanks,
Ray Hunter
Firmware Engineer
ENTERASYS NETWORKS
Phone: 801 887-9888
Fax: 801 972-5789
Email: rhunter(at)enterasys(dot)com
www: www.enterasys.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erle Czar Mantos | 2002-02-28 02:36:45 | Re: Large Objects |
| Previous Message | Wei Weng | 2002-02-27 23:20:22 | Re: How slow is DISTINCT? |