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
thefix 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
Postgresis on our development list for the last few years, but we are just too busy with new projects, and don't have
enoughresources 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
anyof the settings makes postmaster fail. I think there must be something that makes Postgres register server settings
incorrectlybecause they exceed the available resources as compared to average system from the time of the release of
thedatabase.
regards,
Darek Czarkowski