Re: PostgreSQL Performance issue

On Tue, Apr 27, 2010 at 5:17 AM, Alban Hertroys
<dalroi@solfertje.student.utwente.nl> wrote:
> On 27 Apr 2010, at 10:11, <A.Bhattacharya@sungard.com> <A.Bhattacharya@sungard.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
thatmuch 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