Home > mailing lists

Re: Large Table - Slow Window Functions (Better Approach?) - Mailing list pgsql-performance

From	Victor Yegorov
Subject	Re: Large Table - Slow Window Functions (Better Approach?)
Date	March 12, 2013 16:37:01
Msg-id	CAGnEboi2634GJbrD5y=tETt3CZY1vLYNBF2v0kczHgOHnODavg@mail.gmail.com Whole thread Raw
In response to	Large Table - Slow Window Functions (Better Approach?) (Jeff Adams - NOAA Affiliate <jeff.adams@noaa.gov>)
List	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,

--
Victor Y. Yegorov

From: Jeff Adams - NOAA Affiliate
Date: 12 March 2013, 16:08:39
Subject: Re: Large Table - Slow Window Functions (Better Approach?)

From: Shaun Thomas
Date: 12 March 2013, 16:49:09
Subject: Re: Slow query when used in a view