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

From marcin mank
Subject Re: per table random-page-cost?
Date
Msg-id b1b9fac60910191604r59cc36d3tae146cce6ec1c439@mail.gmail.com
Whole thread Raw
In response to Re: per table random-page-cost?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: per table random-page-cost?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> This proposal is just "hints by the back door", ISTM. As Tom says, there is
> a justification for having it on tablespaces but not on individual tables.

If the parameter is defined as "the chance that a page is in cache"
there is very real physical meaning to it. And this is per-table, not
per-tablespace. A "users" table will likely be fetched from cache all
the time, while a "billing_records" table will be fetched mostly from
disk.

Greetings
Marcin


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: per table random-page-cost?
Next
From: Tom Lane
Date:
Subject: Re: per table random-page-cost?