Re: pgsql BLOB issues

From: Jeremy Andrus <jeremy(at)jeremya(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pgsql BLOB issues
Date: 2003-04-28 05:33:38
Message-ID: 200304280133.38335@jeremy-rokks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/
------------------------

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-04-28 08:19:50 Re: pgsql BLOB issues
Previous Message Tom Lane 2003-04-28 05:00:01 Re: pgsql BLOB issues