Re: 4s query want to run faster

Поиск
Список
Период
Сортировка
От Adonias Malosso
Тема Re: 4s query want to run faster
Дата
Msg-id 8a5d3c890802211311m5fab66d6q865fda1737e47802@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 4s query want to run faster  ("Claus Guttesen" <kometen@gmail.com>)
Ответы Re: 4s query want to run faster  ("Claus Guttesen" <kometen@gmail.com>)
Список pgsql-performance


On Thu, Feb 21, 2008 at 6:10 PM, Claus Guttesen <kometen@gmail.com> wrote:
> The following query takes about 4s to run in a 16GB ram server. Any ideas
> why it doesn´t use index for the primary keys in the join conditions?

Maby random_page_cost is set too high? What version are you using?

Postgresql v. 8.2.1



--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare

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

Предыдущее
От: "Claus Guttesen"
Дата:
Сообщение: Re: 4s query want to run faster
Следующее
От: "Claus Guttesen"
Дата:
Сообщение: Re: 4s query want to run faster