firebird X postgresql 8.1.2 windows, performance comparison

Поиск
Список
Период
Сортировка
От andremachado
Тема firebird X postgresql 8.1.2 windows, performance comparison
Дата
Msg-id 20060314183226.M29726@techforce.com.br
обсуждение исходный текст
Ответы Re: firebird X postgresql 8.1.2 windows, performance comparison  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
Hello,
Many thanks for your suggestions.
I am trying to optimize server configs, as (presumed) my friend already
optimized his queries and firebird windows is executing them fast.
You could see at the new attached file the results of the queries rewrite.
Unfortunately, the first query simply returned the same estimated costs by the
planner.
The second one, using EXISTS, multiplied its cost almost 200 times!
"Exists" is painfully slow.
The shared_buffers was reduced again.
Do you have any suggestions?
Many thanks.
Andre Felipe Machado


Вложения

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

Предыдущее
От: "mcelroy, tim"
Дата:
Сообщение: Re: Vacuum template databases, Urgent: Production probl
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: firebird X postgresql 8.1.2 windows, performance comparison