Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0CCBB2E2D53 for ; Wed, 14 Nov 2007 23:17:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 83110-01 for ; Wed, 14 Nov 2007 23:17:03 -0400 (AST) Received: from vms042pub.verizon.net (vms042pub.verizon.net [206.46.252.42]) by postgresql.org (Postfix) with ESMTP id 532FA2E2D8A for ; Wed, 14 Nov 2007 23:17:09 -0400 (AST) Received: from [192.168.0.251] ([71.251.196.74]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JRJ000PK2FXVCA1@vms042.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 14 Nov 2007 21:16:45 -0600 (CST) Date: Wed, 14 Nov 2007 22:16:45 -0500 From: Jean-David Beyer Subject: Re: Curious about dead rows. In-reply-to: <473BB6D9.6090908@emolecules.com> To: pgsql performance Message-id: <473BBA1D.2050702@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> <473B4AB4.70506@sime.com> <473B6398.9030507@verizon.net> <20071114213504.GW19014@alvh.no-ip.org> <473BB6D9.6090908@emolecules.com> User-Agent: Thunderbird 1.5.0.9 (X11/20070317) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/230 X-Sequence-Number: 27645 Craig James wrote: > Alvaro Herrera wrote: >> To recap: >> >> - your app only does inserts >> - there has been no rollback lately >> - there are no updates >> - there are no deletes >> >> The only other source of dead rows I can think is triggers ... do you >> have any? (Not necessarily on this table -- perhaps triggers on other >> tables can cause updates on this one). >> >> Oh, rolled back COPY can cause dead rows too. > > > What about an unreliable network that causes lot of disconnects? > Wouldn't the server process do a rollback? > Perhaps in theory, but in practice my client and the postgreSQL servers are on the same machine and the 127.0.0.1 is pretty reliable: lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:30097919 errors:0 dropped:0 overruns:0 frame:0 TX packets:30097919 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:931924602 (888.7 MiB) TX bytes:931924602 (888.7 MiB) -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 22:10:01 up 22 days, 15:28, 0 users, load average: 4.25, 4.21, 4.12