Skip site navigation (1) Skip section navigation (2)

Re: Curious about dead rows.

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Curious about dead rows.
Date: 2007-11-15 03:02:49
Message-ID: 473BB6D9.6090908@emolecules.com (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

Responses

pgsql-performance by date

Next:From: Jean-David BeyerDate: 2007-11-15 03:16:45
Subject: Re: Curious about dead rows.
Previous:From: Jeff FrostDate: 2007-11-15 02:19:17
Subject: Re: dell versus hp

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group