Re: About "ERROR: must be *superuser* to COPY to or from a file" - Mailing list pgsql-general

From Tom Lane
Subject Re: About "ERROR: must be *superuser* to COPY to or from a file"
Date
Msg-id 15823.1125244229@sss.pgh.pa.us
Whole thread Raw
In response to Re: About "ERROR: must be *superuser* to COPY to or from a file"  (Greg Stark <gsstark@mit.edu>)
Responses Re: About "ERROR: must be *superuser* to COPY to or from a file"  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> In any case here's some quick results from my system. There seems to a greater
> than 21% slowdown associated with piping the data through two processes
> instead of reading directly.

Well, if the penalty is order of 20% (as opposed to integer multiples)
I think the discussion is over.  We're not going to introduce arguable
security holes for that sort of gain --- there are other places we could
find that much speedup for much less risk.

(BTW, were you testing CVS tip or 8.0?  The recent COPY FROM speedup
patch would have affected this test.)

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: : Re: A strange problem
Next
From: Alvaro Herrera
Date:
Subject: Re: Problem upgrading from 8.0.1 to 8.0.3