Re: per-tablespace random_page_cost/seq_page_cost

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: per-tablespace random_page_cost/seq_page_cost
Дата
Msg-id 407d949e0910260909n3c0ef06dp5ad2eba4cedf1103@mail.gmail.com
обсуждение исходный текст
Ответ на per-tablespace random_page_cost/seq_page_cost  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Sun, Oct 25, 2009 at 9:05 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> Arguably, you would expect parameters set using this syntax to be
> stored similar to reloptions - that is, as text[].  But as we're going
> to need these values multiple times per table to plan any non-trivial
> query, I don't want to inject unnecessary parsing overhead and code
> complexity.

Two comments, perhaps complementary, though I'm not sure of either answer.

1 Would we rather the storage scheme allow for future GUCs to be
easily moved to per-tablespace as well without changing the catalog
schema for every option? (Someone might accuse me of trolling the
anti-EAV people here though...)

2 Would it make sense to slurp these options from the tablespace
options into the relcache when building the relcache entry for a
table? That would make the storage format in the tablespace options
much less relevant. It might even make the catcache less important
too.

--
greg


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David E. Wheeler"
Дата:
Сообщение: Re: [ANNOUNCE] PostgreSQL 8.5alpha2 Now Available
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: License clarification: BSD vs MIT