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