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