Alvaro Herrera wrote:
> To recap:
> - your app only does inserts
> - there has been no rollback lately
> - there are no updates
> - there are no deletes
> The only other source of dead rows I can think is triggers ... do you
> have any? (Not necessarily on this table -- perhaps triggers on other
> tables can cause updates on this one).
> Oh, rolled back COPY can cause dead rows too.
What about an unreliable network that causes lot of disconnects? Wouldn't the server process do a rollback?
In response to
pgsql-performance by date
|Next:||From: Jean-David Beyer||Date: 2007-11-15 03:16:45|
|Subject: Re: Curious about dead rows.|
|Previous:||From: Jeff Frost||Date: 2007-11-15 02:19:17|
|Subject: Re: dell versus hp|