pg_dump and --inserts / --column-inserts - Mailing list pgsql-general

From Thomas Kellerer
Subject pg_dump and --inserts / --column-inserts
Date
Msg-id i1p5ld$3lk$1@dough.gmane.org
Whole thread Raw
Responses Re: pg_dump and --inserts / --column-inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

the explanation of the --inserts option of pg_dumps states that

"The --column-inserts option is safe against column order changes, though even slower."

The way I read this is, that
   INSERT INTO table (column, ...) VALUES ...
is slower than
   INSERT INTO table VALUES ...

Is that really true?
Why would explicitely stating the columns be slower than relying on implicit column ordering?


Regards
Thomas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Full Text Search dictionary issues
Next
From: Ivan Voras
Date:
Subject: Re: Full Text Search dictionary issues