"Daniel T. Staal" <DStaal@usa.net> writes:
> The odd thing is that while this is a moderately complex query; three
> tables, multiple 'union's, etc, *all* the tables involved are fairly
> static. The biggest (and the one I've confirmed makes the difference when
> I vacuum it) would be having a busy week if there were ten inserts.
> Deletes are even rarer.
What about updates? Updating an existing row generates vacuumable trash...
regards, tom lane