Hi,
I would like to limit Vertica's resources as much as possible. It is inteded for functional testing where the perfomance does not matter and only small amount of data is required. So changing general pool seems to be what I want, however it requires restart of Vertica and spread.
alter resource pool general MAXMEMORYSIZE '1G' runtimepriority LOW runtimeprioritythreshold 0 executionparallelism 1;
Is there a way to set these parametrs in any config file - before Vertica starts?
Cheers,
Vlad
Limiting Vertica's resources
Moderator: NorbertKrupa
Re: Limiting Vertica's resources
Hi!
>> however it requires restart of Vertica and spread.
Hm... No, it do NOT require to restart Vertica or spread, just apply your parameters.
Also you can change the run-time priority of a query that is actively running (function CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY for example).
PS: Docs: Setting Run-Time Priority for the Resource Pool
>> however it requires restart of Vertica and spread.
Hm... No, it do NOT require to restart Vertica or spread, just apply your parameters.
Also you can change the run-time priority of a query that is actively running (function CHANGE_CURRENT_STATEMENT_RUNTIME_PRIORITY for example).
PS: Docs: Setting Run-Time Priority for the Resource Pool
Re: Limiting Vertica's resources
It really requires restart, once you issue the command, it gives this warning:sKwa wrote: >> however it requires restart of Vertica and spread.
Hm... No, it do NOT require to restart Vertica or spread, just apply your parameters.
NOTICE 2585: Change takes effect upon restart. Recovering nodes will use the new value
ALTER RESOURCE POOL
I was watching the top and only after the restart of the daemon the changes took an effect. This is only for the global pool - general, for user defined pools the changes are immediate.
Re: Limiting Vertica's resources
Hi!
Ok, I never tried to limit a memory for general pool, but what are you doing is wrong way. Instead of limiting GENERAL pool try to limit memory of user or group.
PS:
Ok, I never tried to limit a memory for general pool, but what are you doing is wrong way. Instead of limiting GENERAL pool try to limit memory of user or group.
Code: Select all
/etc/security/limits.conf
From docs:
MEMORYSIZE --- Ignore if tuning the GENERAL pool.
MAXMEMORYSIZE --- Ignore if tuning the GENERAL pool.
Re: Limiting Vertica's resources
That's a good idea, thanks.