Re: [HACKERS] autovacuum and orphaned large objects

2011-10-24 Thread Euler Taveira de Oliveira
On 24-10-2011 11:36, Tom Lane wrote: Euler Taveira de Oliveira writes: The main point of autovacuum is maintenance tasks. Currently, it executes VACUUM and ANALYZE commands. I want to propose that we incorporate vacuumlo functionality into it. I'm not terribly thrilled with that because (a) l

Re: [HACKERS] autovacuum and orphaned large objects

2011-10-24 Thread Euler Taveira de Oliveira
On 24-10-2011 10:57, Robert Haas wrote: I think the main reason why vacuumlo is a contrib module rather than in core is that it is just a heuristic, and it might not be what everyone wants to do. You could store a bunch of large objects in the database and use the returned OIDs to generate links

Re: [HACKERS] autovacuum and orphaned large objects

2011-10-24 Thread Robert Haas
On Mon, Oct 24, 2011 at 12:56 AM, Euler Taveira de Oliveira wrote: > The main point of autovacuum is maintenance tasks. Currently, it executes > VACUUM and ANALYZE commands. I want to propose that we incorporate vacuumlo > functionality into it. While dealing with large objects (LO), we have lo >

Re: [HACKERS] autovacuum and orphaned large objects

2011-10-24 Thread Tom Lane
Euler Taveira de Oliveira writes: > The main point of autovacuum is maintenance tasks. Currently, it executes > VACUUM and ANALYZE commands. I want to propose that we incorporate vacuumlo > functionality into it. I'm not terribly thrilled with that because (a) large objects seem like mostly a l

Re: [HACKERS] autovacuum and orphaned large objects

2011-10-24 Thread Robert Haas
On Mon, Oct 24, 2011 at 10:25 AM, Euler Taveira de Oliveira wrote: > On 24-10-2011 10:57, Robert Haas wrote: >> >> I think the main reason why vacuumlo is a contrib module rather than >> in core is that it is just a heuristic, and it might not be what >> everyone wants to do.  You could store a bu

[HACKERS] autovacuum and orphaned large objects

2011-10-23 Thread Euler Taveira de Oliveira
Hi, The main point of autovacuum is maintenance tasks. Currently, it executes VACUUM and ANALYZE commands. I want to propose that we incorporate vacuumlo functionality into it. While dealing with large objects (LO), we have lo contrib module that helps with LO maintenance but has some limitati