Vertica running in nice mode

[brendon987]

I have just setup a Vertica Prod environment. When we populate this database from the ETL, we notice that "Vertica" is running in Nice mode i.e other processes will run in before Vertica. Is this a Vertica setting ?. Or is it something from the ETL.

[Josh]

Are you talking about the nice mode in linux?

[alamb]

Vertica internally runs most of its threads at a lower priority (higher nice value)

Specifically, Vertica runs its query executor threads with a slightly lower priority than its main communications dispatch loop (note that without being root, a process can not increase the priority of a thread). This is done so that heavy CPU load during query processing doesn't starve out distributed coordination messages.

[JimKnicely]

I believe you can check the nice level in the /etc/security/limits.conf file...