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

Re: Curious about dead rows.

From: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
To: Jean-David Beyer <jeandavid8(at)verizon(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Curious about dead rows.
Date: 2007-11-14 21:46:05
Message-ID: 473B6C9D.1020804@pws.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
Jean-David Beyer wrote:
> [snip]
> 2007-11-14 12:00:31 EST DEBUG:  analyzing "public.vl_in"
> 2007-11-14 12:00:31 EST DEBUG:  "vl_in": scanned 2001 of 2001 pages,
> containing 183983 live rows and 52 dead rows; 3000 rows in sample, 183983
> estimated total rows
> 2007-11-14 12:00:31 EST DEBUG:  analyzing "public.vl_cf"
> 2007-11-14 12:00:31 EST DEBUG:  "vl_cf": scanned 1064 of 1064 pages,
> containing 134952 live rows and 89 dead rows; 3000 rows in sample, 134952
> estimated total rows
> 2007-11-14 12:00:31 EST DEBUG:  analyzing "public.vl_as"
> 2007-11-14 12:00:31 EST DEBUG:  "vl_as": scanned 1732 of 1732 pages,
> containing 134952 live rows and 120 dead rows; 3000 rows in sample, 134952
> estimated total rows
> 2007-11-14 12:00:31 EST DEBUG:  analyzing "public.vl_ranks"
> 2007-11-14 12:00:31 EST DEBUG:  "vl_ranks": scanned 1485 of 1485 pages,
> containing 188415 live rows and 162 dead rows; 3000 rows in sample, 188415
> estimated total rows
> 2007-11-14 12:00:31 EST DEBUG:  analyzing "public.vl_mi"
> 2007-11-14 12:00:31 EST DEBUG:  "vl_mi": scanned 1325 of 1325 pages,
> containing 134952 live rows and 191 dead rows; 3000 rows in sample, 134952
> estimated total rows
> 2007-11-14 12:00:31 EST DEBUG:  analyzing "public.vl_li"
> 2007-11-14 12:00:31 EST DEBUG:  "vl_li": scanned 1326 of 1326 pages,
> containing 134952 live rows and 218 dead rows; 3000 rows in sample, 134952
> estimated total rows
>   
What does vacuum verbose have to say about this situation?
It is possible that analyze is not getting the number of dead rows right?
Does analyze, followed by vacuum verbose give the same dead row counts?

Sorry for lots of questions, I'm just throwing ideas into the mix.

Russell.
>   


In response to

Responses

pgsql-performance by date

Next:From: Jean-David BeyerDate: 2007-11-14 21:51:44
Subject: Re: Curious about dead rows.
Previous:From: Alvaro HerreraDate: 2007-11-14 21:35:04
Subject: Re: Curious about dead rows.

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