Re: Join slow on "large" tables

Поиск
Список
Период
Сортировка
От Josué Maldonado
Тема Re: Join slow on "large" tables
Дата
Msg-id 40C4FA85.8070205@lamundial.hn
обсуждение исходный текст
Ответ на Re: Join slow on "large" tables  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Josh,

El 07/06/2004 5:21 PM, Josh Berkus en su mensaje escribio:
>
> Huh?   It is not at all the same.   Your index scan is down to 87ms from
> 27,000!   And the total query is down to 16seconds from 47 seconds.   Don't
> you consider that an improvement?

Yes there was an improvement with respect the previus query, but still
16 seconds is too slow for that query. And usually the query takes more
than 10 seconds even with small data sets returned.

Thanks,


--
Sinceramente,
Josué Maldonado.

"La cultura es capaz de descifrar los enigmas en que nos envuelve la vida."

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Join slow on "large" tables
Следующее
От: Duane Lee - EGOVX
Дата:
Сообщение: Re: is it possible to for the planner to optimize this