| From: | Rafal Kedziorski <rafcio(at)polonium(dot)de> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Good performance? |
| Date: | 2003-02-17 09:12:45 |
| Message-ID: | 3E50A78D.9000806@polonium.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomasz Myrta | 2003-02-17 10:58:57 | Re: [PERFORM] Good performance? |
| Previous Message | Barry Lind | 2003-02-17 04:45:01 | Re: Good performance? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chantal Ackermann | 2003-02-17 10:51:56 | Re: cost and actual time |
| Previous Message | Barry Lind | 2003-02-17 04:45:01 | Re: Good performance? |