Re: Huge Performance Difference on Similar Query in Pg7.2

Поиск
Список
Период
Сортировка
От Luis Alberto Amigo Navarro
Тема Re: Huge Performance Difference on Similar Query in Pg7.2
Дата
Msg-id 00ad01c1d189$22887ee0$cab990c1@atc.unican.es
обсуждение исходный текст
Ответ на Huge Performance Difference on Similar Query in Pg7.2  (Heiko Klein <Heiko.Klein@met.no>)
Ответы Re: Huge Performance Difference on Similar Query in Pg7.2  (Heiko Klein <Heiko.Klein@met.no>)
Список pgsql-general
first of all the difference between expected times and real times may be
reduced tuning your postgresql.conf
try to set enable_seqscan to off and then re explain analyze to see if there
is another possible solution
Regards


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

Предыдущее
От: Heiko Klein
Дата:
Сообщение: Re: Huge Performance Difference on Similar Query in Pg7.2
Следующее
От: Heiko Klein
Дата:
Сообщение: Re: Huge Performance Difference on Similar Query in Pg7.2