Slightly faster version of vacuumlo - Mailing list pgsql-hackers

From Denis Perchine
Subject Slightly faster version of vacuumlo
Date
Msg-id 00060714445102.00505@dyp
Whole thread Raw
List pgsql-hackers
Hello all,

I tried to use vacuumlo on quite big database with large objects (approx 20000-30000).
And I found out that it will take 5-6 hours to cleanup blobs even when there's no unlinked ones.
I've looked inside the code and added some improvements.
Now it took 20-30 seconds to complete.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use of system indexes
Next
From: Hannu Krosing
Date:
Subject: Re: Problems with char array set to NULL