Re: pgsql BLOB issues - Mailing list pgsql-performance

From Jeremy Andrus
Subject Re: pgsql BLOB issues
Date
Msg-id 200304280133.38335@jeremy-rokks
Whole thread Raw
In response to Re: pgsql BLOB issues  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Monday 28 April 2003 01:00 am, Tom Lane wrote:
> Are you talking about 500MB in one BLOB, or 500MB total?

  I meant 500MB _total_. There are over 5000 separate BLOBs.

  I'll ask my friendly sys-admin to vacuum pg_largeobject, and I'll let
you know what happens :-) In general though, how much performance is
really gained through regular vacuuming?

Thanks for your help,

    -Jeremy

--
------------------------
Jeremy C. Andrus
http://www.jeremya.com/
------------------------


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql BLOB issues
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pgsql BLOB issues