"Daniel T. Staal" <DStaal(at)usa(dot)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
In response to
pgsql-novice by date
|Next:||From: atsorgassa||Date: 2006-05-11 08:45:25|
|Subject: insert performance|
|Previous:||From: Sean Davis||Date: 2006-05-10 23:04:54|
|Subject: Re: error handling|