On 09/25/2010 10:03 AM, Tom Lane wrote:
rey<reywang@xxxxxxxxxxxxx> 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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
