Re: Column correlation drifts, index ignored again

Поиск
Список
Период
Сортировка
От Kevin Brown
Тема Re: Column correlation drifts, index ignored again
Дата
Msg-id 20040224212419.GF3090@filer
обсуждение исходный текст
Ответ на Re: Column correlation drifts, index ignored again  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: Column correlation drifts, index ignored again
Следующее
От: Robert Treat
Дата:
Сообщение: Re: [HACKERS] [SQL] Materialized View Summary