Re: [PERFORM] Good performance?

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Rafal Kedziorski <rafcio(at)polonium(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Good performance?
Date: 2003-02-17 10:58:57
Message-ID: 3E50C071.3090806@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-performance

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).
Regards,
Tomasz Myrta

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rafal Kedziorski 2003-02-17 11:25:22 Re: [PERFORM] Good performance?
Previous Message Rafal Kedziorski 2003-02-17 09:12:45 Re: Good performance?

Browse pgsql-performance by date

  From Date Subject
Next Message Rafal Kedziorski 2003-02-17 11:25:22 Re: [PERFORM] Good performance?
Previous Message Chantal Ackermann 2003-02-17 10:51:56 Re: cost and actual time