Re: Postgresql 7.3 on Red Hat Enterprise 5 (Problem with SEMMNI, SEMMNS)

I am sorry, it seams that my last replay never reached the list.

I was looking for the list of changes for each version, but this document is bundled with the source. I believe it is the fix introduced in version 7.3.5:
"* Fix insertion of expressions containing subqueries into rule bodies"
Above line is from HISTORY file, and our application is just abusing this feature. Upgrade to newest version of Postgres is on our development list for the last few years, but we are just too busy with new projects, and don't have enough resources to commit to it. You have to understand that an upgrade would halt any development for an unspecified time.

Getting new version of operating system is not that much of a problem, we trust Redhat to deliver reliable operating system, and we do build PostgresSQL from source anyway.

I have settled for 250 connections and 810 shared buffers, this is just to get the server ready for deployment. Rising any of the settings makes postmaster fail. I think there must be something that makes Postgres register server settings incorrectly because they exceed the available resources as compared to average system from the time of the release of the database.

regards,
Darek Czarkowski