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

Re: Curious about dead rows.

From: Jean-David Beyer <jeandavid8(at)verizon(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Curious about dead rows.
Date: 2007-11-13 19:50:59
Message-ID: 473A0023.5020609@verizon.net (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andrew Sullivan wrote:
> Please don't drop the list, as someone else may see something.
> 
> On Tue, Nov 13, 2007 at 10:06:13AM -0500, Jean-David Beyer wrote:
>> OK. I turned logging from "none" to "mod" and got a gawdawful lot of stuff.
> 
> Yes.
> 
>> Then I ran it and got all the inserts. Using
>> grep -i delete file
>> grep -i update file
>> grep -i rollback file
> 
> How about ERROR?

$ grep -i error Tue.log
$
> 
>> 2007-11-13 08:11:20 EST DEBUG:  "vl_ranks": scanned 540 of 540 pages,
>> containing 67945 live rows and 554 dead rows; 3000 rows in sample, 67945
>> estimated total rows
> 
> If there are dead rows, something is producing them.  Either INSERT is
> firing a trigger that is doing something there (you won't see an UPDATE in
> that case), or else something else is causing INSERTs to fail.

I have no triggers in that database. I do have two sequences.

                  List of relations
 Schema |          Name          |   Type   |  Owner
- --------+------------------------+----------+---------
 public | company_company_id_seq | sequence | jdbeyer
 public | source_source_id_seq   | sequence | jdbeyer

stock=> \d company_company_id_seq
Sequence "public.company_company_id_seq"
    Column     |  Type
- ---------------+---------
 sequence_name | name
 last_value    | bigint
 increment_by  | bigint
 max_value     | bigint
 min_value     | bigint
 cache_value   | bigint
 log_cnt       | bigint
 is_cycled     | boolean
 is_called     | boolean

stock=> \d source_source_id_seq
Sequence "public.source_source_id_seq"
    Column     |  Type
- ---------------+---------
 sequence_name | name
 last_value    | bigint
 increment_by  | bigint
 max_value     | bigint
 min_value     | bigint
 cache_value   | bigint
 log_cnt       | bigint
 is_cycled     | boolean
 is_called     | boolean

but they are not used after the last VACUUM FULL ANALYZE


- --
  .~.  Jean-David Beyer          Registered Linux User 85642.
  /V\  PGP-Key: 9A2FC99A         Registered Machine   241939.
 /( )\ Shrewsbury, New Jersey    http://counter.li.org
 ^^-^^ 14:40:01 up 21 days, 7:58, 2 users, load average: 4.33, 4.43, 4.39
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with CentOS - http://enigmail.mozdev.org

iD8DBQFHOgAiPtu2XpovyZoRApmZAKDH2JaSlxH+DT1rs8E110P9L4r5+ACZAYGY
z2SQtUvRDHlpCwePE2cskX4=
=xS8V
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-performance by date

Next:From: Jeff FrostDate: 2007-11-13 20:32:18
Subject: Re: dell versus hp
Previous:From: Alan HodgsonDate: 2007-11-13 15:49:49
Subject: Re: dell versus hp

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