From: Kevin Brown <kevin@sysexperts.com>
To: Postgres Performance <pgsql-performance@postgresql.org>
Subject: Re: Column correlation drifts, index ignored again
Date: Tue, 24 Feb 2004 13:24:19 -0800
Message-ID: <20040224212419.GF3090@filer> (raw)
In-Reply-To: <200402241354.15025.pgsql@bluepolka.net>
References: <BC5E98B7.2DCB2%siracusa@mindspring.com>
<23533.1077647386@sss.pgh.pa.us>
<20040224201419.GD3090@filer>
<200402241354.15025.pgsql@bluepolka.net>
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/<db-oid>/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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kevin@sysexperts.com
Subject: Re: Column correlation drifts, index ignored again
In-Reply-To: <20040224212419.GF3090@filer>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox