On Tue, Apr 27, 2010 at 5:17 AM, Alban Hertroys <dal...@solfertje.student.utwente.nl> wrote: > On 27 Apr 2010, at 10:11, <a.bhattacha...@sungard.com> > <a.bhattacha...@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 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
