X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E4B59D1EC4E for ; Fri, 2 Apr 2004 06:32:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71138-05 for ; Fri, 2 Apr 2004 02:32:17 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id AE36AD1EC43 for ; Fri, 2 Apr 2004 02:32:13 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i326WBJi023110; Fri, 2 Apr 2004 01:32:11 -0500 (EST) To: "Gary Doades" Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL and Linux 2.6 kernel. In-reply-to: <406C7956.17885.4B2DCD2@localhost> References: <406C7956.17885.4B2DCD2@localhost> Comments: In-reply-to "Gary Doades" message dated "Thu, 01 Apr 2004 20:19:34 +0100" Date: Fri, 02 Apr 2004 01:32:10 -0500 Message-ID: <23109.1080887530@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/7 X-Sequence-Number: 6307 "Gary Doades" writes: > As a test in PosgreSQL I issued a statement to update a single column > of a table containing 2.8 million rows with the values of a column in > a table with similar rowcount. Using the above spec I had to stop the > server after 17 hours. The poor thing was thrashing the hard disk and > doing more swapping than useful work. This statement is pretty much content-free, since you did not show us the table schemas, the query, or the EXPLAIN output for the query. (I'll forgive you the lack of EXPLAIN ANALYZE, but you could easily have provided all the other hard facts.) There's really no way to tell where the bottleneck is. Maybe it's a kernel-level issue, but I would not bet on that without more evidence. I'd definitely not bet on it without direct confirmation that the same query plan was used in both setups. regards, tom lane