[Info-ingres] Reducing the number of CPUs in an Ingres Installation

Steve s.anderson.au at gmail.com
Tue Oct 20 07:29:44 UTC 2020


On Friday, October 16, 2020 at 6:54:04 PM UTC+11, Martin Bowes wrote:
> > For example, will reducing the number of CPUs require me to re-install Ingres or unload the database?
> No.

So "simply" shut down Ingres, let the admin to their thing and then startup Ingres again?

> > I see from the Installation Guide there is an Ingres environment variable II_NUM_OF_PROCESSORS - it's set to 2 in the installation, which bares absolutely no resemblance to the number of CPUs! :o
> I think it's more of a flag 1 means 1 but 2 means 2 or more. 

Yes, I did wonder that.

> BTW. We did the reduce the cpu thing a year ago...and were pleasantly surprised at how well the system continued to run. 

OK. I think we might find the same thing; CPU utilisation is normally very low.

Thanks
Steve



More information about the Info-ingres mailing list