Re: Possible to improve query plan?

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

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Um, that looks like 90 usec per row, not msec.

Oh, right. Well, having to do a random heap access for 1% of the
rows would pretty much explain the run time, then.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dimi Paun 2011-01-24 18:29:01 How to use indexes for GROUP BY
Previous Message Tom Lane 2011-01-24 17:33:34 Re: Possible to improve query plan?