Postgres Pro
Downloads
Home   >   mailing lists

Re: psql copy command - 1 char limitation on delimiter - Mailing list pgsql-general

From rey
Subject Re: psql copy command - 1 char limitation on delimiter
Date
Msg-id 4C9E49B7.6050005@optonline.net
Whole thread Raw
In response to Re: psql copy command - 1 char limitation on delimiter  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql copy command - 1 char limitation on delimiter  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
On 09/25/2010 10:03 AM, Tom Lane wrote:
> rey<reywang@optonline.net>  writes:
>
>> Why limit this to a single character?
>>
> Performance.  Believe it or not, breaking fields at the delimiter is
> a significant factor in COPY speed.
>
>             regards, tom lane
>
>
True, but just for 5% to 10% degradation here.
For RDBMS, correct indexes and good logical design we are talking about
10 times or more performance gains.

Who cares about 10% waste here? Is it Oracle and other commercial RDBMS
no such limitation.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg 8.4 crashing.
Next
From: Jason Long
Date:
Subject: Streaming Replication