Fedora People – Fedora Magazine: Use cpulimit to free up your CPU

Jun 142021
 

The recommended tool for managing system resources on Linux systems is cgroups. While very powerful in terms of what sorts of limits can be tuned (CPU, memory, disk I/O, network, etc.), configuring cgroups is non-trivial. The nice command has been available since 1973. But it only adjusts the scheduling priority among processes that are competing for time on a processor. The nice command will not limit the percentage of CPU cycles that a process can consume per unit of time. The cpulimit command provides the best of both worlds. It limits the percentage of CPU cycles that a process can allocate per unit of time and it is relatively easy to invoke. The cpulimit command…

External feed Read More at the Source: https://fedoramagazine.org/use-cpulimit-to-free-up-your-cpu/

 2021-06-14  Comments Off on Fedora People – Fedora Magazine: Use cpulimit to free up your CPU

Planet PostgreSQL – Hans-Juergen Schoenig: Data warehousing: Making use of synchronized seq scans

Jun 142021
 

PostgreSQL contains some hidden gems which have been around for many years and help to silently speed up your queries. They optimize your SQL statements in a clever and totally transparent way. One of those hidden gems is the ability to synchronize sequential scans. Actually, this feature has been around for 15+ years, but has gone mostly unnoticed by many end-users. However, if you are running data warehouses and analytical workloads, you might have already used synchronized seq scans without actually knowing it.
Reducing I/O for large SQL queries
Before we draw any conclusions, it is necessary to understand the problem we’re trying to solve in the first place. Consider the following scenario: 10 users are concurrently running…

External feed Read More at the Source: https://postgr.es/p/55L

 2021-06-14  Comments Off on Planet PostgreSQL – Hans-Juergen Schoenig: Data warehousing: Making use of synchronized seq scans