Re: psql copy command - 1 char limitation on delimiter

Поиск
Список
Период
Сортировка
От rey
Тема Re: psql copy command - 1 char limitation on delimiter
Дата
Msg-id 4C9E49B7.6050005@optonline.net
обсуждение исходный текст
Ответ на Re: psql copy command - 1 char limitation on delimiter  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: psql copy command - 1 char limitation on delimiter  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg 8.4 crashing.
Следующее
От: Jason Long
Дата:
Сообщение: Streaming Replication