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

Re: Curious about dead rows.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-10 17:08:11
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Jean-David Beyer <jeandavid8(at)verizon(dot)net> writes:
> I am doing lots of INSERTs on a table that starts out empty (I did a
> TRUNCATE on it). I am not, AFAIK, doing DELETEs or UPDATEs. Autovacuum is
> on. I moved logging up to debug2 level to see what was going on, and I get
> things like this:

>  "vl_as": scanned 3000 of 5296 pages, containing 232944 live rows and 1033
> dead rows; 3000 rows in sample, 411224 estimated total rows

> A little later, it says:

> "vl_as": scanned 3000 of 6916 pages, containing 233507 live rows and 493
> dead rows; 3000 rows in sample, 538311 estimated total rows

Well, *something* is doing deletes or updates in that table.  Better
look a bit harder at your application ...

			regards, tom lane

In response to


pgsql-performance by date

Next:From: Jean-David BeyerDate: 2007-11-10 18:38:23
Subject: Re: Curious about dead rows.
Previous:From: Jean-David BeyerDate: 2007-11-10 16:27:07
Subject: Curious about dead rows.

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