Re: The vacuum-ignore-vacuum patch - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: The vacuum-ignore-vacuum patch
Date
Msg-id 200607121522.45771.peter_e@gmx.net
Whole thread Raw
In response to The vacuum-ignore-vacuum patch  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-patches
Am Dienstag, 11. Juli 2006 23:01 schrieb Alvaro Herrera:
> One exception is that we can't do that with full vacuums.  The reason is
> that full vacuum may want to run user-defined functions to be able to
> index the tuples it moves.  This isn't a problem normally, except in the
> case where the function tries to scan some other table: if we ignored
> that transaction, then another lazy vacuum might delete tuples from that
> table that we need to see.

Functions in the index expression must be immutable, so I don't think that is
a real concern.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-patches by date:

Previous
From: Greg Stark
Date:
Subject: Re: reply to ...
Next
From: "Larry Rosenman"
Date:
Subject: Re: [patch 0/9] annual pgcrypto update