From: | Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: autovacuum and orphaned large objects |
Date: | 2011-10-24 14:25:16 |
Message-ID: | 4EA5754C.9060901@timbira.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 that you email to
> users, and then when the user clicks on the link we retrieve the
> corresponding LO and send it to the user over HTTP. In that design,
> there are no tables in the database at all, yet the large objects
> aren't orphaned.
>
Uau, what a strange method to solve a problem and possibly bloat your
database. No, I'm not suggesting that we forbid it. The proposed method could
cleanup orphaned LO in 95% (if not 99%) of the use cases.
I've never heard someone using LO like you describe it. It seems strange that
someone distributes an OID number but (s)he does not store its reference at
the same database. Yes, it is a possibility but ...
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
From | Date | Subject | |
---|---|---|---|
Next Message | Omar Bettin | 2011-10-24 14:29:37 | R: [9.1] unusable for large views (SOLVED) |
Previous Message | Magnus Hagander | 2011-10-24 14:16:49 | Re: Updated version of pg_receivexlog |