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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/