Re: fillfactor using WITH syntax - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Re: fillfactor using WITH syntax
Date
Msg-id 20060607145633.B945.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: fillfactor using WITH syntax  (Simon Riggs <simon@2ndquadrant.com>)
List 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 by date:

Previous
From: Greg Stark
Date:
Subject: Re: DROP INHERITS
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Compression and on-disk sorting