Re: [PERFORM] Good performance?

Поиск
Список
Период
Сортировка
От Rafal Kedziorski
Тема Re: [PERFORM] Good performance?
Дата
Msg-id 3E50C6A2.2000504@polonium.de
обсуждение исходный текст
Ответ на Good performance?  (Rafal Kedziorski <rafcio@polonium.de>)
Список pgsql-jdbc
Tomasz Myrta wrote:

> Rafal Kedziorski wrote:
> <cut>
>
>> 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
>
> It is possible when you have "fsync=false" in your postgresql.conf.
> (don't change it if you don't have to).

fsync is:
#fsync = true

but there are my new start options: postmaster -i -o -F -D ...

after set fsync false I get this Performance for creating new entries
with entity beans:

needed 9223 for creating 1000 entries

instead of about 50.000 milliseconds. it's possible to make it faster?


Rafal

> Regards,

> Tomasz Myrta



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

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