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

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pginfo <pginfo@t1.unisoftbg.com>
Cc: Richard_D_Levine@raytheon.com, Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg primary key bug?
Date: Mon, 21 Feb 2005 17:51:34 -0500
Message-ID: <3293.1109026294@sss.pgh.pa.us> (raw)
In-Reply-To: <421992FE.3030108@t1.unisoftbg.com>
References: <OFEF67063C.F61988F3-ON05256F9D.005A91D6@ftw.us.ray.com>
	<4214B466.20908@t1.unisoftbg.com>
	<8125.1108661189@sss.pgh.pa.us>
	<4214C94F.2050806@t1.unisoftbg.com>
	<9340.1108664352@sss.pgh.pa.us>
	<4214D5C3.4070107@t1.unisoftbg.com>
	<9785.1108666900@sss.pgh.pa.us>
	<421992FE.3030108@t1.unisoftbg.com>

pginfo <pginfo@t1.unisoftbg.com> writes:
> sorry, but we have the case number 3 in with the same problem.
> Also this time we do not find any linux box crash nor pg stop or restart.

Hmm, well there's *something* mighty curious about the history of this
table.  The xmin values span a range of almost 400,000 transactions and
yet the oids are twenty-three consecutive values.  Is this the only
table you've inserted into during the last 400K transactions?

It's also odd that there's so much empty space (only 37 rows in 60
pages).  It's hard to see how that could be unless there were many
updates on the table, but judging from the name and contents of the
table I can hardly see a reason for lots of updates.  How is this table
used exactly?  Do you do UPDATEs on it?  DELETEs?  SELECT FOR UPDATE?
Do you do VACUUM, or VACUUM FULL, or both?

			regards, tom lane



view thread (27+ messages)  latest in thread

Message-ID: <3293.1109026294@sss.pgh.pa.us>
Permalink:  ../3293.1109026294@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3293.1109026294@sss.pgh.pa.us

 · 

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-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pginfo@t1.unisoftbg.com, grzm@myrealbox.com
  Subject: Re: pg primary key bug?
  In-Reply-To: <3293.1109026294@sss.pgh.pa.us>

* 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