Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 498D89F95B9 for ; Sat, 10 Nov 2007 22:11:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 09869-08 for ; Sat, 10 Nov 2007 22:11:06 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by postgresql.org (Postfix) with ESMTP id B25519F9594 for ; Sat, 10 Nov 2007 22:11:05 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so1221152waf for ; Sat, 10 Nov 2007 18:11:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=61I2vLQaF8p+ZkjjPjwjlPVqLXXdAC33YEVlPR6u4Po=; b=upagThIIXc1l4l0gfZKOUJBBFsJKHPENCB3cEO9xOD5c4Wn+uKqVhYgV9oKrnHRkbs2pmzMQ5+GvvR1hWcE0N/gZrNBmVx89pKyk3IK6/HoOzWPqebZVdcpba5xgkJmUt/U8LJuTLolWB+CkQanvuf0/K691GqG0wLCHuz0iysE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=PtS7/XbdQRjIx+/KKk2FfZFJLgCWgRHREcvTAXjvU4UEqQTML9i79t6PsWa683Q4lm92DYQYcG9neOoVB8WUz4LhMBiK+K0BljdQwmyC3JRYEg/dzr7SrkQZUIUECizyh/rdTdaYL79qdkDUyql0qL3FETIu0Omjr+oKSTDcZiY= Received: by 10.114.61.1 with SMTP id j1mr1339748waa.1194747063781; Sat, 10 Nov 2007 18:11:03 -0800 (PST) Received: by 10.114.171.20 with HTTP; Sat, 10 Nov 2007 18:11:03 -0800 (PST) Message-ID: Date: Sat, 10 Nov 2007 20:11:03 -0600 From: "Scott Marlowe" To: "Jean-David Beyer" Subject: Re: Curious about dead rows. Cc: "pgsql performance" In-Reply-To: <47360D16.7070107@verizon.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4735DBDB.5050208@verizon.net> <16627.1194714491@sss.pgh.pa.us> <4735FA9F.1080805@verizon.net> <20071110105119.35346a29@scratch> <47360D16.7070107@verizon.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/167 X-Sequence-Number: 27582 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.