large object thx & vacuuming question

From: rpetike(at)freemail(dot)hu
To: pgsql-general(at)postgresql(dot)org
Subject: large object thx & vacuuming question
Date: 2002-04-27 00:41:48
Message-ID: Pine.LNX.4.21.0204270241220.1002-100000@pepehost.ike
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Thank you Tom for the fast answer about lo ids!

* * *

On an other server we use Postgres7.1. Everything is fine (:-), but I
have a question:
We have a dozen tables, and ~40000 los (300MegBytes) in a db. When I
run vacuum verbose in this db, I experience that when vacuum reaches the
pg_largeobjects table, it starts eating up disk space, and never
(can't wait?) finishes. Is it sensible vacuuming pg_largeobjects? All
our other tables can be vacuumed in a few seconds time.
Sorry for my terrible english, I hope you can understand it...

thanks: Peter RISKO

Browse pgsql-general by date

  From Date Subject
Next Message postgres 2002-04-27 02:52:35 intel vs amd benchmark for pg server part 2
Previous Message Lincoln Yeoh 2002-04-27 00:31:02 Re: delete column