Обсуждение: pg 8.4 (Auto)-vacuumlo
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
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