Re: Hash join on int takes 8..114 seconds

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Hash join on int takes 8..114 seconds
Дата
Msg-id op.ukv3hnsfcigqcu@soyouz
обсуждение исходный текст
Ответ на Hash join on int takes 8..114 seconds  ("Andrus" <kobruleht2@hot.ee>)
Ответы Re: Hash join on int takes 8..114 seconds  ("Andrus" <kobruleht2@hot.ee>)
Список pgsql-performance
> Query below seems to use indexes everywhere in most optimal way.
> dokumnr column is of type int
>
> Speed of this query varies rapidly:
>
> In live db fastest response I have got is 8 seconds.
> Re-running same query  after 10 seconds may take 60 seconds.
> Re-running it again after 10 seconds may take 114 seconds.
>
> Any idea how to speed it up ?
>
> Is it possible to optimize it, will upgrading to 8.3.5 help or should I
> require to add more RAM, disk or CPU speed ?
>
> Real query contains column list instead of sum(1) used in test below.
>
> Andrus.

    Just a question, what are you doing with the 20.000 result rows ?

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

Предыдущее
От: "Andrus"
Дата:
Сообщение: Hash join on int takes 8..114 seconds
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Very Urgent : Sequences Problem