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 Treat||Date: 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|