Limiting Vertica's resources

Moderator: NorbertKrupa

Post Reply
vlada
Newbie
Newbie
Posts: 3
Joined: Thu May 02, 2013 4:49 pm

Limiting Vertica's resources

Post by vlada » Fri May 03, 2013 9:35 am

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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Limiting Vertica's resources

Post by id10t » Fri May 03, 2013 6:29 pm

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

vlada
Newbie
Newbie
Posts: 3
Joined: Thu May 02, 2013 4:49 pm

Re: Limiting Vertica's resources

Post by vlada » Fri May 03, 2013 8:23 pm

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.
It really requires restart, once you issue the command, it gives this warning:
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.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Limiting Vertica's resources

Post by id10t » Fri May 03, 2013 11:26 pm

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.

Code: Select all

/etc/security/limits.conf
PS:
From docs:
MEMORYSIZE --- Ignore if tuning the GENERAL pool.
MAXMEMORYSIZE --- Ignore if tuning the GENERAL pool.

vlada
Newbie
Newbie
Posts: 3
Joined: Thu May 02, 2013 4:49 pm

Re: Limiting Vertica's resources

Post by vlada » Sat May 04, 2013 6:38 am

That's a good idea, thanks.

Post Reply

Return to “Vertica Performance Tuning”