On Mon, Apr 7, 2014 at 3:55 PM, Johann Spies <johann.sp...@gmail.com> wrote:
> > > I then ran the query and the result was produced in about the same time as > (2945 ms). > > What can cause such a huge discrepancy? > May be when you reran the query, most of the data blocks were cached either in the shared buffers or the OS cache. That could drastically improve the performance. I can see a large number of shared buffer hits in the explain analyze output of the query ran through psql session. Thanks, Pavan -- Pavan Deolasee http://www.linkedin.com/in/pavandeolasee
