Re: [PERFORMANCE] work_mem vs temp files issue

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [PERFORMANCE] work_mem vs temp files issue
Дата
Msg-id 603c8f071001130824u3e0be910lfea14c3e475c8256@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORMANCE] work_mem vs temp files issue  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Ответы Re: [PERFORMANCE] work_mem vs temp files issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Wed, Jan 13, 2010 at 11:14 AM, Jaime Casanova
<jcasanov@systemguards.com.ec> wrote:
> On Wed, Jan 13, 2010 at 11:11 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> Well, what about when we're just doing EXPLAIN, not EXPLAIN ANALYZE?
>> It'll add another line to the output for the expected number of
>> batches.
>
> and when we are in EXPLAIN ANALYZE the real number as well?

Yeah.  My question is whether it's acceptable to add an extra line to
the EXPLAIN output for every hash join, even w/o ANALYZE.

...Robert

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: a heavy duty operation on an "unused" table kills my server
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: a heavy duty operation on an "unused" table kills my server