Andy Dale wrote:
Hi,
I have performed some tests earlier on today, and i think the problem lies
with Postgres and it's bad performance when being used with container
managed persistence.
Is your problem performance or an error? It sounded like you were
getting errors in your first post.
> I am covinced of it being an issue with postgres
because it works really well with MySQL and Hypersonic, but not with
Postgres.
*What* works really well? Can you tell us what query/queries are giving
you problems?
> I have been reading around on the internet and it seems that
Postgres does not work too well with container managed persistence, but
surely all i have to do is just change some configuration settings, or can
Postgres not be used with container managed persistence.
If you generate valid SQL then PostgreSQL can certainly process the
queries. As to whether tuning will help, nobody can say because you
haven't supplied details of:
1. Hardware
2. Operating System
3. Queries giving problems
4. Concurrency details
5. Current configuration settings
6. System activity (is CPU/RAM/IO maxed?)
Without at least *some* of these facts nobody can say anything useful.
--
Richard Huxton
Archonet Ltd
