Re: Performance/Issues with CMP and JBoss

"Andy Dale" <andy(dot)dale(at)gmail(dot)com> writes:

> The current problem we seem to have is that the data is persisted ok
> (or at least it seems to be in there with pgadmin), but cannot be
> read back out of the database all the time (in fact for about 90% of
> the time), the current behaviour of the application suggests it is
> trying to read it back out of the database (using
> EntityManager.find()) before it has really been saved, and thus
> fails to find the data. Do i have to tweak some settings in the
> postgres.conf file ? i have tried turning off fsync (i do not want
> to do this, for reliability reasons) and it performed far better.
> Can anyone advise me on the changes i need to make to speed up the
> inserting of data, i know that turning autocommit off is supposed to
> increase performance.

This is almost certainly a problem with your persistence layer rather
than with Postgres. If you can see the data with PGAdmin then it's in
the database. It may be that the transaction that saves the object is
not committing quickly, and so other connections don't see the object
until the commit happens. But that's not the fault of Postgres.

-Doug