Skip site navigation (1) Skip section navigation (2)

Re: Large Objects

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 (view raw or flat)
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

In response to

Responses

pgsql-sql by date

Next:From: Erle Czar MantosDate: 2002-02-28 02:36:45
Subject: Re: Large Objects
Previous:From: Wei WengDate: 2002-02-27 23:20:22
Subject: Re: How slow is DISTINCT?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group