On Monday 01 September 2003 22:08, Vivek Khera wrote:
> I use it in 24/7/365 system which is heavily written to and read
> from. The drawbacks I have are:
Nitpik: that should be 24/7/52, since there aren't 365 weeks in a year.
> 1) upgrade to major versions require dump/restore which is a
> significant amount of downtime for a large DB.
I have harped on this at length. Maybe one day we'll get real upgrading.
Search the archives for the discussions; there are many, and they are long
threads.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
