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

[Victor Yegorov <vyegorov@xxxxxxxxx>]

2013/3/11 Jeff Adams - NOAA Affiliate <jeff.adams@xxxxxxxx>

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