Re: large objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cedar Cox <cedarc(at)visionforisrael(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: large objects
Date: 2002-06-30 00:02:32
Message-ID: 16308.1025395352@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Cedar Cox <cedarc(at)visionforisrael(dot)com> writes:
> I've been away from the PG scene for a while now and I haven't been
> keeping up with the news. Does PG support vacuuming of large
> objects yet? If no, is there a method to do this manually from a
> cron job or something?

> What I have in mind is to build an image library. File sizes will
> probably range from 500K to 2MB.

Don't bother with large objects; just store the images as 'bytea'
column values.

regards, tom lane

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2002-07-02 06:11:52 Re: pgaccess - current status
Previous Message Bruce Badger 2002-06-29 11:57:37 Re: Frontend - Backend protocol change?