| 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: | 16627.1194714491@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-David Beyer | 2007-11-10 18:38:23 | Re: Curious about dead rows. |
| Previous Message | Jean-David Beyer | 2007-11-10 16:27:07 | Curious about dead rows. |