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 <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Curious about dead rows.
Date: 2007-11-11 02:22:58
Message-ID: 47366782.7050600@verizon.net (view raw or flat)
Thread:
Lists: pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Scott Marlowe wrote:
> On Nov 10, 2007 1:57 PM, Jean-David Beyer <jeandavid8(at)verizon(dot)net> wrote:
>> Joshua D. Drake wrote:
>>> Truncate will not create dead rows. However ROLLBACK will. Are you
>>> getting any duplicate key errors or anything like that when you insert?
>>>
>> On the mistaken assumption that TRUNCATE left dead rows, I did a
>> VACUUM FULL ANALYZE before running the program full of INSERTs. This did not
>> make any difference.
>>
>> As far as ROLLBACK are concerned, every one is immediately preceded by a
>> message output to the standard error file, and no such messages are produced.
> 
> So, there are NO failed inserts, and no updates?  Cause that's what
> I'd expect to create the dead rows.
> 
So would I. Hence the original question.

- --
  .~.  Jean-David Beyer          Registered Linux User 85642.
  /V\  PGP-Key: 9A2FC99A         Registered Machine   241939.
 /( )\ Shrewsbury, New Jersey    http://counter.li.org
 ^^-^^ 21:20:01 up 18 days, 14:38, 0 users, load average: 4.38, 4.40, 4.31
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with CentOS - http://enigmail.mozdev.org

iD8DBQFHNmeBPtu2XpovyZoRAqxzAJ9wLNf7Y9egSd/COtMjWaqKWfJXowCfdDj7
HEulOz8v4DKtAqWCGTf/22Y=
=79AU
-----END PGP SIGNATURE-----

In response to

Responses

pgsql-performance by date

Next:From: DimitriDate: 2007-11-11 19:27:02
Subject: Re: PostgreSQL vs MySQL, and FreeBSD
Previous:From: Scott MarloweDate: 2007-11-11 02:11:03
Subject: Re: Curious about dead rows.

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