Re: per table random-page-cost? - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: per table random-page-cost?
Date
Msg-id 1256007937.2580.30.camel@jdavis
Whole thread Raw
In response to Re: per table random-page-cost?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: per table random-page-cost?
List pgsql-hackers
On Mon, 2009-10-19 at 21:22 -0500, Kevin Grittner wrote:
> I'd bet accounts receivable applications often hit that.
> (Most payments on recent billings; a sprinkling on older ones.)
> I'm sure there are others.

You worded the examples in terms of writes (I think), and we're talking
about read caching, so I still don't entirely understand.

Also, the example sounds like you'd like to optimize across queries.
There's no mechanism for the planner to remember some query executed a
while ago, and match it up to some new query that it's trying to plan.
Maybe there should be, but that's an entirely different feature. 

I'm not clear on the scenario that we're trying to improve.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: per table random-page-cost?
Next
From: Bruce Momjian
Date:
Subject: Re: Rejecting weak passwords