Set FILLFACTOR for primary key

--000000000000221b8405947ce649
Content-Type: text/plain; charset="UTF-8"

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

--000000000000221b8405947ce649
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I have a table where I INSERT rows and DELETE rows. Howeve=
r, they are UPDATEd. Therefore, I&#39;ve set FILLFACTOR to 100% for all of =
the indexes. However, I can&#39;t figure out how to set the FILLFACTOR to 1=
00 for the primary key. I think it&#39;s just a matter of syntax that I can=
&#39;t seem to wrap my head around.=C2=A0<div><br></div><div>My code looks =
like:<br><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><=
font face=3D"monospace">ALTER TABLE table ADD CONSTRAINT table_pkey PRIMARY=
 KEY (col1, col2) USING INDEX TABLESPACE ts_indexes;</font></blockquote><di=
v><br></div><div>How should this be changed to set the FILLFACTOR or am I m=
issing something fundamental about primary keys?</div></div><div><br></div>=
<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 -Ed=C2=A0</div></div>

--000000000000221b8405947ce649--