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
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 |