Re: Insert performance for large transaction with multiple COPY FROM

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Insert performance for large transaction with multiple COPY FROM
Дата
Msg-id CAGTBQparVsrQkLJ2di=NHKvdXgdVxPEePMaN=s=GkRxrvFx_kg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Insert performance for large transaction with multiple COPY FROM  (Horst Dehmer <horst.dehmer@gmail.com>)
Ответы Re: Insert performance for large transaction with multiple COPY FROM  (Horst Dehmer <horst.dehmer@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Sat, Jan 12, 2013 at 5:16 PM, Horst Dehmer <horst.dehmer@gmail.com> wrote:
> Yes, the ids is something I don't like either.
> They carry additional semantics, which I cannot make go away.
> How are chances char(20) is more time efficient than numeric(20)?
> Disk space is no problem here.

What are the other tables like then?

The exact data types involved are at issue here, so it matters.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Insert performance for large transaction with multiple COPY FROM
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Insert performance for large transaction with multiple COPY FROM