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?


Reply via email to