Re: Curious about dead rows.

[Craig James <craig_james(at)emolecules(dot)com>]

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?

Craig