Skip site navigation (1) Skip section navigation (2)

Re: Column correlation drifts, index ignored again

From: Kevin Brown <kevin(at)sysexperts(dot)com>
To: Postgres Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Column correlation drifts, index ignored again
Date: 2004-02-24 21:24:19
Message-ID: 20040224212419.GF3090@filer (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)sysexperts(dot)com

In response to

pgsql-performance by date

Next:From: Robert TreatDate: 2004-02-24 21:48:49
Subject: Re: [HACKERS] [SQL] Materialized View Summary
Previous:From: Ed L.Date: 2004-02-24 20:54:15
Subject: Re: Column correlation drifts, index ignored again

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group