Re: [PERFORM] EXISTS optimization

Поиск
Список
Период
Сортировка
От Peter Kovacs
Тема Re: [PERFORM] EXISTS optimization
Дата
Msg-id b6e8f2e80703231604v72b9dc4dr51eebd62274d53ec@mail.gmail.com
обсуждение исходный текст
Ответ на Re: EXISTS optimization  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
On 3/23/07, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
[...]
> That's the good news.  The bad news is that I operate under a management portability dictate which doesn't currently
allowthat syntax, since not all of the products they want to
 

It doesn't really touch the substance, but I am curious: are you not
even allowed to discriminate between products in your code like:
if db is 'postresql' then
...
else
...
?

What would be the rationale for that?

Thanks
Peter

cover support it.  I tried something which seems equivalent, but it is
running for a very long time.  I'll show it with just the explain
while I wait to see how long the explain analyze takes.
>
[...]


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

Предыдущее
От: "Florian G. Pflug"
Дата:
Сообщение: Re: tsearch_core for inclusion
Следующее
От: Koichi Suzuki
Дата:
Сообщение: Full page writes improvement, code update