ITAGAKI Takahiro wrote:
> Bruce Momjian wrote:
>
> > > - Is fillfactor useful for hash and gist indexes?
> > > I think hash does not need it, but gist might need it.
> >
> > Not sure. We don't know what type of index a GIST will be so we have no
> > way of knowing. I am thinking we can imp
Bruce Momjian wrote:
> > - Is fillfactor useful for hash and gist indexes?
> > I think hash does not need it, but gist might need it.
>
> Not sure. We don't know what type of index a GIST will be so we have no
> way of knowing. I am thinking we can implement just btree now and the
> GIST f
Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > Compatibility problems? CREATE INDEX isn't an SQL standard command is it?
>
> No, but it'll cause unnecessary cross-version compatibility issues for
> us.
It is true it isn't SQL standard, but I think our CREATE INDEX synt
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Compatibility problems? CREATE INDEX isn't an SQL standard command is it?
No, but it'll cause unnecessary cross-version compatibility issues for
us.
regards, tom lane
---(end of broadcast)-
If you want it to be dumped by pg_dump (which is debatable IMHO) then
it MUST NOT be a syntax extension, it has to be driven by a GUC
variable, else we have compatibility problems with the dumps. We just
went through this with WITH/WITHOUT OIDS.
Compatibility problems? CREATE INDEX isn't an SQ
Tom Lane wrote:
> Bruce Momjian writes:
> >> - Should indexes remember their fillfactors when they are created?
> >> The last fillfactors will be used on next reindex.
>
> > They should remember, for sure, and REINDEX should use it. It think
> > this is similar to the ALTER TABLE ALTER [ COLUMN
Bruce Momjian writes:
>> - Should indexes remember their fillfactors when they are created?
>> The last fillfactors will be used on next reindex.
> They should remember, for sure, and REINDEX should use it. It think
> this is similar to the ALTER TABLE ALTER [ COLUMN ] ... SET STATISTICS
> func
ITAGAKI Takahiro wrote:
> Hi Hackers,
>
> I'm trying the following TODO item:
> [Indexes]
> - Add fillfactor to control reserved free space during index creation
>
> I have already made an patch and it seemed to work well.
Great.
> And now, I need advice on some issues.
>
> - Is it appr
Hi Hackers,
I'm trying the following TODO item:
[Indexes]
- Add fillfactor to control reserved free space during index creation
I have already made an patch and it seemed to work well.
$ ./pgbench -i -s 10
# select relpages from pg_class where relname = 'accounts_pkey';
relpages | 27