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

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Jeff Adams - NOAA Affiliate <jeff(dot)adams(at)noaa(dot)gov>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Large Table - Slow Window Functions (Better Approach?)
Date: 2013-03-12 13:36:54
Message-ID: CAGnEboi2634GJbrD5y=tETt3CZY1vLYNBF2v0kczHgOHnODavg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shaun Thomas 2013-03-12 13:49:04 Re: Slow query when used in a view
Previous Message Jeff Adams - NOAA Affiliate 2013-03-12 13:08:31 Re: Large Table - Slow Window Functions (Better Approach?)