pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: Jean-David Beyer <jeandavid8@verizon.net>
To: pgsql-performance@postgresql.org
Subject: Re: Curious about dead rows.
Date: Tue, 13 Nov 2007 10:21:11 -0500
Message-ID: <20071113152111.GG11563@crankycanuck.ca> (raw)
In-Reply-To: <4739BD65.9070605@verizon.net>
References: <dcc563d10711101811l6bc7a521vc299f5fdbb6b7a6e@mail.gmail.com>
	<47366782.7050600@verizon.net>
	<20071112163223.GP32349@crankycanuck.ca>
	<4738825F.6050106@verizon.net>
	<20071112171805.GQ32349@crankycanuck.ca>
	<47389504.4020700@verizon.net>
	<20071112185218.GS32349@crankycanuck.ca>
	<4738A2EC.9090500@verizon.net>
	<20071112190833.GY32349@crankycanuck.ca>
	<4739BD65.9070605@verizon.net>

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?

> 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.

A

-- 
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke



view thread (41+ messages)  latest in thread

Message-ID: <20071113152111.GG11563@crankycanuck.ca>
Permalink:  ../20071113152111.GG11563@crankycanuck.ca/
Also on:    postgresql.org/message-id/20071113152111.GG11563@crankycanuck.ca

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: ajs@crankycanuck.ca, jeandavid8@verizon.net
  Subject: Re: Curious about dead rows.
  In-Reply-To: <20071113152111.GG11563@crankycanuck.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox