pg_dump performance lossage for primary keys - Mailing list pgsql-hackers

I notice that pg_dump now dumps primary-key indexes in the style

CREATE TABLE ... ("dest_index" integer DEFAULT ...,Constraint "dest_addresses_pkey" Primary Key ("dest_index")
);

...

COPY ...  FROM stdin;
-- load data
\.

-- create other indexes for table

Isn't this pretty darn stupid?  Previously, we created indexes after
loading the data.  We're going to take a huge performance hit to do it
this way.

IMHO it would be better to reach in and set the "primary key" flag on
the index after creating it normally.
        regards, tom lane