Re: postgres 8 performance

> I can't figure out what the problem is.
> The app using jdbc and the postmaster instance were running on the same
> comp so I can't believe that communication would make that big a hit on
> performance.

It's the query parsing that takes a lot of time.
You might want to look at prepared statements:
http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html

Also set autocommit to off and do a hundert or so inserts inside
one transaction, not one transaction for each insert.

Bye, Chris.