Re: Best COPY Performance

Поиск
Список
Период
Сортировка
От Worky Workerson
Тема Re: Best COPY Performance
Дата
Msg-id ce4072df0610272043j4e1e41e5rb0701c66d4db21bd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Best COPY Performance  ("Luke Lonergan" <llonergan@greenplum.com>)
Список pgsql-performance
> Worky (that your real name? :-)

Nope, its Mike.  worky.workerson is just the email that I use for "work" :)

> How many CPUs on the machine?  Can you send the result of "cat
> /proc/cpuinfo"?

Not at work at the moment, however I do have quad dual-core opterons,
like Merlin mentioned.

> Is your "cat file | psql" being done on the DBMS server or is it on the
> network?

Everything is currently being done on the same DB server.  The data
that is being loaded is on the same 2-disk "RAID10" as the OS and WAL.

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

Предыдущее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Best COPY Performance
Следующее
От: "Worky Workerson"
Дата:
Сообщение: Re: Best COPY Performance