2013/3/11 Jeff Adams - NOAA Affiliate <jeff(dot)adams(at)noaa(dot)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