What I know for fast loading bulk rows into a new table is:
- Create the table(without creating the index)
- Use "COPY" to load data from a file into the table
- Create the index
What if I added a primary key when creating the table, according to PostgreSQL: "Adding a primary key will automatically create a unique btree index on the column or group of columns used in the primary key.", will the rows be indexed during "COPY" since the table has an implicit index? if the answer is yes, the "COPY" will slow down?