Re: select max() much slower than select min()

Поиск
Список
Период
Сортировка
От Brian Cox
Тема Re: select max() much slower than select min()
Дата
Msg-id 4A3BFDA0.5020308@ca.com
обсуждение исходный текст
Ответ на select max() much slower than select min()  (Brian Cox <brian.cox@ca.com>)
Ответы Re: select max() much slower than select min()
Список pgsql-performance
David Rees [drees76@gmail.com] wrote:
> Along those lines, couldn't you just have the DB do the work?
>
> select max(ts_id), min(ts_id) from ... where ts_interval_start_time >=
> ... and ...
>
> Then you don't have to transfer 500k ids across the network...
I guess you didn't read the entire thread: I started it because the
query you suggest took 15 mins to complete.

Brian


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

Предыдущее
От: David Rees
Дата:
Сообщение: Re: select max() much slower than select min()
Следующее
От: David Rees
Дата:
Сообщение: Re: select max() much slower than select min()