Re: Large Table - Slow Window Functions (Better Approach?)

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: Large Table - Slow Window Functions (Better Approach?)
Дата
Msg-id CAGnEboi2634GJbrD5y=tETt3CZY1vLYNBF2v0kczHgOHnODavg@mail.gmail.com
обсуждение исходный текст
Ответ на Large Table - Slow Window Functions (Better Approach?)  (Jeff Adams - NOAA Affiliate <jeff.adams@noaa.gov>)
Список pgsql-performance
Дерево обсуждения
2013/3/11 Jeff Adams - NOAA Affiliate <jeff.adams@noaa.gov>

Greetings,

 

I have a large table (~90 million rows) containing vessel positions.

  ...



Could you kindly provide a script to create the table and populate it with several sample
rows, please? Also, provide the desired output for the sample rows.

It would be good to take a look on the “EXPLAIN ANALYZE” output of your query,
please, share http://explain.depesz.com/ link.


--
Victor Y. Yegorov

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

Предыдущее
От: Jeff Adams - NOAA Affiliate
Дата:
Сообщение: Re: Large Table - Slow Window Functions (Better Approach?)
Следующее
От: Shaun Thomas
Дата:
Сообщение: Re: Slow query when used in a view