pg 8.4 (Auto)-vacuumlo

Richard Broersma escribi�:

I wanted to verify that the auto-vacuum mechanism of postgres doesn't
apply to lo objects.

It doesn't.

Does vocuumlo still need to be called manually?

Not sure about this. I thought that one was about deleting LOs that
were not referenced in any user table.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

On Fri, Oct 23, 2009 at 8:29 AM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:

Does vocuumlo still need to be called manually?

Not sure about this.  I thought that one was about deleting LOs that
were not referenced in any user table.

Thanks this is correct vacuumlo deletes orphaned LOs.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

Richard Broersma <richard.broersma@gmail.com> writes:

Thanks this is correct vacuumlo deletes orphaned LOs.

Right. That functionality is not part of autovacuum --- if you need it
you'll still need to run the contrib script occasionally.

regards, tom lane