Re: fillfactor using WITH syntax

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: fillfactor using WITH syntax
Дата
Msg-id 20060607145633.B945.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: fillfactor using WITH syntax  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> wrote:
> Itagaki had suggested adding options to heaps also, so clearly we'd need
> to add that to pg_class, rather than pg_index in that case.

Yes, I want to add options tables not only indexes. There is pg_index for
indexes, but is not pg_table for tables, so I added options to pg_class.

> > > Why not implement an array of option parameters on pg_class, so both
> > > heaps and indexes can be given additional parameters? That way you
> > > wouldn't need a specific relfillfactor attribute. That would allow us to
> > > keep CREATE TABLE free of additional keywords also.

Ok, I'll add a options array to pg_class instead of the fixed-field for
fillfactor, referring to the aclitem.

---
ITAGAKI Takahiro
NTT Open Source Software Center




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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: DROP INHERITS
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Compression and on-disk sorting