Re: Possible to improve query plan? - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: Possible to improve query plan?
Date
Msg-id 4D3D64A60200002500039B1E@gw.wicourts.gov
Whole thread Raw
In response to Re: Possible to improve query plan?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Possible to improve query plan?  (Jeremy Palmer <JPalmer@linz.govt.nz>)
List pgsql-performance
Tom Lane <tgl@sss.pgh.pa.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible to improve query plan?
Next
From: Dimi Paun
Date:
Subject: How to use indexes for GROUP BY