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

From Tom Lane
Subject Re: pg_dump and --inserts / --column-inserts
Date
Msg-id 8135.1279377361@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and --inserts / --column-inserts  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: pg_dump and --inserts / --column-inserts  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Thomas Kellerer <spam_eater@gmx.net> writes:
> I'm till a bit surprised that parsing the statement _with_ a column list is mesurably slower than withou a column
list.

Well, nobody's offered any actual *numbers* here.  It's clear that
parsing the column list will take more time than not doing so, but
whether that adds up to anything significant or even measurable
compared to the rest of the statement's cost is not so clear.
Want to do some experiments?

            regards, tom lane

pgsql-general by date:

Previous
From: Leif Biberg Kristensen
Date:
Subject: Re: MESSAGE ERROR
Next
From: Tom Lane
Date:
Subject: Re: Fedora 13 killed dblink this week...