Re: pg_dump and --inserts / --column-inserts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and --inserts / --column-inserts
Date: 2010-07-17 14:36:01
Message-ID: 8135.1279377361@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Kellerer <spam_eater(at)gmx(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-07-17 15:04:22 Re: Fedora 13 killed dblink this week...
Previous Message Leif Biberg Kristensen 2010-07-17 14:19:20 Re: MESSAGE ERROR