Re: Possible to improve query plan?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, JPalmer(at)linz(dot)govt(dot)nz, andy(at)squeakycode(dot)net, pgsql-performance(at)postgresql(dot)org
Subject: Re: Possible to improve query plan?
Date: 2011-01-24 17:31:44
Message-ID: 9614.1295890304@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> But isn't 13.5 seconds awfully slow to scan 149557 rows?

Depends on how many physical blocks they're scattered across, which
is hard to tell from this printout. And on how many of the blocks
are already in cache, and what sort of disk hardware he's got, etc.

> Any chance this is 9.0.X? It'd be interesting to see the EXPLAIN
> (ANALYZE, BUFFERS) output for this query.

Yeah.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2011-01-24 17:33:34 Re: Possible to improve query plan?
Previous Message Kevin Grittner 2011-01-24 16:50:41 Re: Possible to improve query plan?