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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org