Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9236D9F95CD for ; Sat, 10 Nov 2007 22:23:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 86988-09 for ; Sat, 10 Nov 2007 22:22:57 -0400 (AST) Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id 593869F95B9 for ; Sat, 10 Nov 2007 22:23:03 -0400 (AST) Received: from [192.168.0.251] ([71.251.196.74]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JRB00FF8LAABEU8@vms048.mailsrvcs.net> for pgsql-performance@postgresql.org; Sat, 10 Nov 2007 20:22:59 -0600 (CST) Date: Sat, 10 Nov 2007 21:22:58 -0500 From: Jean-David Beyer Subject: Re: Curious about dead rows. In-reply-to: To: pgsql performance Message-id: <47366782.7050600@verizon.net> Organization: Institute for Regimented Whimsey MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Enigmail-Version: 0.94.0.0 References: <4735DBDB.5050208@verizon.net> <16627.1194714491@sss.pgh.pa.us> <4735FA9F.1080805@verizon.net> <20071110105119.35346a29@scratch> <47360D16.7070107@verizon.net> User-Agent: Thunderbird 1.5.0.9 (X11/20070317) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/168 X-Sequence-Number: 27583 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Scott Marlowe wrote: > On Nov 10, 2007 1:57 PM, Jean-David Beyer 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-----