Hans-Jürgen Schönig wrote:
> When doing multiple insert, please consider the following: PostgreSQL
> uses fsync (I think) after every insert. This is extremely slow when
> inserting large amounts of data at once. On the other hand this helps
> you to protect the database if the systems crashes.
I would have thought fsync() would be slowest when inserting lots of
little pieces of data, not big ones. But I'm just guessing.
You can disable fsync() with the '-o -F' flag to postmaster. This speeds
everything up, but if your system crashes you may lose some data.
Regards,
Neil
