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

From marcin mank
Subject Re: per table random-page-cost?
Date
Msg-id b1b9fac60910191517w137a0832h544ecd211697fb4e@mail.gmail.com
Whole thread Raw
In response to Re: per table random-page-cost?  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: per table random-page-cost?
Re: per table random-page-cost?
Re: per table random-page-cost?
List pgsql-hackers
> I've been thinking about this a bit, too.  I've been wondering if it
> might make sense to have a "random_page_cost" and "seq_page_cost"
> setting for each TABLESPACE, to compensate for the fact that different
> media might be faster or slower, and a percent-cached setting for each
> table over top of that.
>

I thought about making it per-table, but realistically I think most
people don`t use tablespaces now. I would not want to be telling
people "to be able to hint the planner to (not) index-scan the table,
You must move it to a separate tablespace".

A global default, a per-tablespace default overriding it, and a
per-table value overriding them both seems like over-engineering to
me.

Greetings
Marcin


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: per table random-page-cost?
Next
From: marcin mank
Date:
Subject: Re: per table random-page-cost?