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