autovacuum and orphaned large objects

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: autovacuum and orphaned large objects
Date: 2011-10-24 04:56:47
Message-ID: 4EA4F00F.3040208@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 limitations (does
not handle DROP TABLE and TRUNCATE cases) and vacuumlo that does an excellent
job but have to be executed outside DBMS. The proposal is to clean up LO when
autovacuum triggers VACUUM; cleanup LO routine will starts after(?) VACUUM
command.

In a near future I want to propose that orphaned LO be cleaned up by VACUUM
but that a history for another thread...

Comments?

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Pflug 2011-10-24 06:05:01 Re: Hot Backup with rsync fails at pg_clog if under load
Previous Message Simon Riggs 2011-10-23 23:33:59 Re: Hot Backup with rsync fails at pg_clog if under load