Re: handling TOAST tables in autovacuum

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: handling TOAST tables in autovacuum
Date: 2008-06-09 19:11:40
Message-ID: 484D806C.2030208@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera napsal(a):
> Hi,
>
> We've been making noises about dealing with TOAST tables as separate
> entities in autovacuum for some time now. So here's a proposal:

Maybe dumb idea - whats about make a queue of toast pointers ready for vacuum
and remove this toast items directly from toast table and index?

Zdenek

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-06-09 20:35:27 Re: Overhauling GUCS
Previous Message Alvaro Herrera 2008-06-09 18:07:28 Re: pg_dump restore time and Foreign Keys