I have a table where I INSERT rows and DELETE rows. However, they are
UPDATEd. Therefore, I've set FILLFACTOR to 100% for all of the indexes.
However, I can't figure out how to set the FILLFACTOR to 100 for the
primary key. I think it's just a matter of syntax that I can't seem to wrap
my head around.
My code looks like:
ALTER TABLE table ADD CONSTRAINT table_pkey PRIMARY KEY (col1, col2) USING
> INDEX TABLESPACE ts_indexes;
How should this be changed to set the FILLFACTOR or am I missing something
fundamental about primary keys?
-Ed