pg_dump and --inserts / --column-inserts

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump and --inserts / --column-inserts
Date: 2010-07-16 08:35:56
Message-ID: i1p5ld$3lk$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2010-07-16 10:23:10 Re: Full Text Search dictionary issues
Previous Message Howard Rogers 2010-07-16 04:22:19 Re: Full Text Search dictionary issues