Re: [GENERAL] pg 8.4 (Auto)-vacuumlo

2009-10-23 Thread Tom Lane
Richard Broersma 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 -- Sent via pgsql-general mailing list (p

Re: [GENERAL] pg 8.4 (Auto)-vacuumlo

2009-10-23 Thread Richard Broersma
On Fri, Oct 23, 2009 at 8:29 AM, Alvaro Herrera 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

Re: [GENERAL] pg 8.4 (Auto)-vacuumlo

2009-10-23 Thread Alvaro Herrera
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. --

[GENERAL] pg 8.4 (Auto)-vacuumlo

2009-10-23 Thread Richard Broersma
I wanted to verify that the auto-vacuum mechanism of postgres doesn't apply to lo objects. Does vocuumlo still need to be called manually? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing l