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

Re: Curious about dead rows.

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Jean-David Beyer <jeandavid8(at)verizon(dot)net>
Cc: pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Curious about dead rows.
Date: 2007-11-14 21:35:04
Message-ID: 20071114213504.GW19014@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
Jean-David Beyer wrote:
> Mario Weilguni wrote:

> > Did you rollback some transactions? It will generate dead rows too - at
> > least I think so.
> > 
> No, and the statistics confirm this.

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.

-- 
Alvaro Herrera                               http://www.PlanetPostgreSQL.org/
"Before you were born your parents weren't as boring as they are now. They
got that way paying your bills, cleaning up your room and listening to you
tell them how idealistic you are."  -- Charles J. Sykes' advice to teenagers

In response to

Responses

pgsql-performance by date

Next:From: Russell SmithDate: 2007-11-14 21:46:05
Subject: Re: Curious about dead rows.
Previous:From: Jean-David BeyerDate: 2007-11-14 21:07:36
Subject: Re: Curious about dead rows.

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