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 087DFD1B901 for ; Tue, 24 Feb 2004 21:24:21 +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 96648-05 for ; Tue, 24 Feb 2004 17:24:21 -0400 (AST) Received: from filer (c-24-6-183-218.client.comcast.net [24.6.183.218]) by svr1.postgresql.org (Postfix) with ESMTP id 22AFED1B860 for ; Tue, 24 Feb 2004 17:24:18 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Tue, 24 Feb 2004 13:24:19 -0800 Date: Tue, 24 Feb 2004 13:24:19 -0800 From: Kevin Brown To: Postgres Performance Subject: Re: Column correlation drifts, index ignored again Message-ID: <20040224212419.GF3090@filer> Mail-Followup-To: Kevin Brown , Postgres Performance References: <23533.1077647386@sss.pgh.pa.us> <20040224201419.GD3090@filer> <200402241354.15025.pgsql@bluepolka.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <200402241354.15025.pgsql@bluepolka.net> Organization: Frobozzco International User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/289 X-Sequence-Number: 5813 Ed L. wrote: > How do you know the merge join is spilling to disk? How are you identifying > that? Just assuming from vmstat? iostat? The existence of files in $PG_DATA/base//pgsql_tmp while the query is running, combined with the EXPLAIN output (which shows what sorts and joins are being performed). -- Kevin Brown kevin@sysexperts.com