Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order
Дата
Msg-id 25650.1043281284@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> I am very strongly in favor of this idea.   I would personally prefer it if
> the Join collapsing parmeter could be set at query time through a SET
> statement, but will of course defer to the difficulty level in doing so.

I guess I failed to make it clear that that's what I meant.  GUC
variables are those things that you can set via SET, or in the
postgresql.conf file, etc.  These values would be just as manipulable
as, say, ENABLE_SEQSCAN.

> How about:
> EXPLICIT_JOIN_MINIMUM
> and
> FROM_COLLAPSE_LIMIT

> Just to make the two params not sound so identical?

Hmm.  The two parameters would have closely related functions, so I'd
sort of think that the names *should* be pretty similar.

            regards, tom lane

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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Terrible performance on wide selects
Следующее
От: "Dann Corbit"
Дата:
Сообщение: Re: Terrible performance on wide selects