Re: optimizer cost calculation problem

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: optimizer cost calculation problem
Дата
Msg-id Pine.LNX.4.33.0304010910090.13402-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: optimizer cost calculation problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: optimizer cost calculation problem
Список pgsql-hackers
On Mon, 31 Mar 2003, Tom Lane wrote:

> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > BTW it does not 2 gig, but 1 gig (remember that we do sortmembytes *
> > 2) . 
> 
> Good point.  Probably that particular calculation should be
> "sortmembytes * 2.0" to force it to double before it can overflow.
> But I still think we'd better limit SortMem so that the basic
> SortMem*1024 calculation can't overflow (or even come close to overflow,
> likely).

This isn't really an issue for 64 bit hardware is it?



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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Dangling backends on win32 7.2.1 port (peerdirect).
Следующее
От: Tom Lane
Дата:
Сообщение: Re: optimizer cost calculation problem