Postgres Pro
Downloads
Home   >   mailing lists

Re: Column correlation drifts, index ignored again - Mailing list pgsql-performance

From Kevin Brown
Subject Re: Column correlation drifts, index ignored again
Date
Msg-id 20040224212419.GF3090@filer
Whole thread Raw
In response to Re: Column correlation drifts, index ignored again  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-performance
Tree view 
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@sysexperts.com

pgsql-performance by date:

Previous
From: "Ed L."
Date:
Subject: Re: Column correlation drifts, index ignored again
Next
From: Robert Treat
Date:
Subject: Re: [HACKERS] [SQL] Materialized View Summary