From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
Cc: | "<A(dot)Bhattacharya(at)sungard(dot)com>" <A(dot)Bhattacharya(at)sungard(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL Performance issue |
Date: | 2010-04-27 14:31:13 |
Message-ID: | x2zb42b73151004270731y3324a3d6t96cdba3b3b064f6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 27, 2010 at 5:17 AM, Alban Hertroys
<dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> wrote:
> On 27 Apr 2010, at 10:11, <A(dot)Bhattacharya(at)sungard(dot)com> <A(dot)Bhattacharya(at)sungard(dot)com> wrote:
>
>> Dear All Experts,
>>
>> I am using in PostgreSQL 8.3.5 database on windows 64 bit OS.
>> However, I have a batch program written in Java which processes the data and populates them into tables in Postgres database.
>>
>> I have 622,000 number of records but it is taking almost 4 and half hours to load these data into the tables.
>
> Wow, that's averaging almost 40s per insert! I don't think those inserts not being in a single transaction explains that much of a delay. Not that changing that doesn't help, but there's more going on here.
You got that backwards: it's 40 inserts/sec. This is about par for
the course on windows style fsync on slow hardware iirc. Solution is
to use transactions, or play with fsync.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Bayless Kirtley | 2010-04-27 14:31:56 | Re: PostgreSQL Performance issue |
Previous Message | Tom Lane | 2010-04-27 14:25:47 | Re: lc_ctype does not work on windows ? |