From: | Rafal Kedziorski <rafcio(at)polonium(dot)de> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: [PERFORM] Good performance? |
Date: | 2003-02-17 11:25:22 |
Message-ID: | 3E50C6A2.2000504@polonium.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2003-02-17 12:27:37 | Re: [JDBC] Good performance? |
Previous Message | Tomasz Myrta | 2003-02-17 10:58:57 | Re: [PERFORM] Good performance? |
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2003-02-17 12:27:37 | Re: [JDBC] Good performance? |
Previous Message | Tomasz Myrta | 2003-02-17 10:58:57 | Re: [PERFORM] Good performance? |