Re: merge>hash>loop

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: merge>hash>loop
Дата
Msg-id 19433.1145399208@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: merge>hash>loop  (Markus Schaber <schabi@logix-tt.com>)
Ответы Re: merge>hash>loop  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Markus Schaber <schabi@logix-tt.com> writes:
> Hmm, how does effective_cach_size correspond with it? Shouldn't a high
> effective_cache_size have a similar effect?

It seems reasonable to suppose that effective_cache_size ought to be
used as a number indicating how much "stuff" would hang around from
query to query.  Right now it's not used that way...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: merge>hash>loop
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: creating of temporary table takes very long