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