Re: Good performance?

Поиск
Список
Период
Сортировка
От Rafal Kedziorski
Тема Re: Good performance?
Дата
Msg-id 3E50A78D.9000806@polonium.de
обсуждение исходный текст
Ответ на Re: Good performance?  (Barry Lind <blind@xythos.com>)
Ответы Re: Good performance?  (Barry Lind <blind@xythos.com>)
Список pgsql-jdbc
hi,

Barry Lind wrote:

> Rafal,
>
> Performance of postgres running under cygwin isn't great.  Can you try
> the same test on a different platform?  It also looks like you are
> running in autocommit mode.  You should see a significant performance
> improvement if you batch your commits in say groups of 1000 inserts
> per commit.

after set autocommit false, I need 0,9 - 1,04 seconds for insert 1000
new entries into my table. is this normal, that autocommit false is
40-50 times slower?


Rafal

> thanks,
> --Barry




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

Предыдущее
От: Barry Lind
Дата:
Сообщение: Re: Good performance?
Следующее
От: Rafal Kedziorski
Дата:
Сообщение: Re: [PERFORM] Good performance?