2013/3/11 Jeff Adams - NOAA Affiliate <jeff.ad...@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