Re: Performance over a LAN

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Performance over a LAN
Дата
Msg-id 4100A9FE.2020905@familyhealth.com.au
обсуждение исходный текст
Ответ на Performance over a LAN  ("William Carney" <wcarney@sa.quiktrak.com.au>)
Ответы Re: Performance over a LAN  (Mark Aufflick <mark@pumptheory.com>)
Список pgsql-performance
> But with the server running on one machine and the client running on
> another, the two machines being connected by a 100 Mb ethernet, with nothing
> else on the network, this test takes 17 minutes to run. I have tried
> changing the frequency of COMMIT operations, but with only a small effect.

Are you using separate INSERT statements?  Try using COPY instead, it's
much faster.

chris


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

Предыдущее
От: "William Carney"
Дата:
Сообщение: Performance over a LAN
Следующее
От: Mark Aufflick
Дата:
Сообщение: Re: Performance over a LAN