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
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
Jun 092021
 

Ring gets a lot of criticism, not just for its massive surveillance network of home video doorbells and its problematic privacy and security practices, but also for giving that doorbell footage to law enforcement. While Ring is making moves towards transparency, the company refuses to disclose how many users had their data given to police.
The video doorbell maker, acquired by Amazon in 2018, has partnerships with at least 1,800 U.S. police departments (and growing) that can request camera footage from Ring doorbells. Prior to a change this week, any police department that Ring partnered with could privately request doorbell camera footage from Ring customers for an active investigation. Ring will now let its police partners publicly request…

External feed Read More at the Source: https://techcrunch.com/2021/06/08/ring-police-warrants-neighbors/

 2021-06-09  Comments Off on TechCrunch – Ring refuses to say how many users had video footage obtained by police
Jun 092021
 

If the majority of council members get what they want, this year’s municipal election would be delayed until November 2022. Not every council member is onboard.

External feed Read More at the Source: https://indyweek.com/news/wake/the-raleigh-council-wants-to-ask-the-legislature-for-an-extra-year-in-office-due-to-pandemic-driven-census-delays/

 2021-06-09  Comments Off on INDY Week – Raleigh’s Council Wants to Ask the Legislature For an Extra Year in Office Due to Pandemic-Driven Census Delays
Jun 092021
 

Ring gets a lot of criticism, not just for its massive surveillance network of home video doorbells and its problematic privacy and security practices, but also for giving that doorbell footage to law enforcement. While Ring is making moves towards transparency, the company refuses to disclose how many users had their data given to police.
The video doorbell maker, acquired by Amazon in 2018, has partnerships with at least 1,800 U.S. police departments (and growing) that can request camera footage from Ring doorbells. Prior to a change this week, any police department that Ring partnered with could privately request doorbell camera footage from Ring customers for an active investigation. Ring will now let its police partners publicly request…

External feed Read More at the Source: https://techcrunch.com/2021/06/08/ring-police-warrants-neighbors/

 2021-06-09  Comments Off on TechCrunch – Ring won’t say how many users had footage obtained by police
Jun 022021
 

Left turns are dangerous and cause a lot of unnecessary traffic. Chris Jongkind/Moment via Getty ImagesTo reduce travel times, fuel consumption and carbon emissions, in 2004, UPS changed delivery routes to minimize the left-hand turns drivers made. Although this seems like a rather modest change, the results are anything but: UPS claims that per year, eliminating left turns – specifically the time drivers sit waiting to cut across traffic – saves 10 million gallons of fuel, 20,000 tons of carbon emissions and allows them to deliver 350,000 additional packages. If it works so well for UPS, should cities seek to eliminate left-hand turns at intersections too? My research suggests the answer is a resounding yes….

External feed Read More at the Source: https://theconversation.com/sick-of-dangerous-city-traffic-remove-left-turns-161397

 2021-06-02  Comments Off on – The Conversation – Home – Sick of dangerous city traffic? Remove left turns
Jun 022021
 

“Lots of venues were—and still obviously are—hanging on by a thread,” says Cat’s Cradle owner Frank Heath.

External feed Read More at the Source: https://indyweek.com/culture/stage/are-triangle-arts-organizations-getting-the-held-they-need/

 2021-06-02  Comments Off on INDY Week – To Survive, Many Triangle Arts Organizations Applied for Federal Aid. Are They Getting the Help They Need?
Jun 012021
 

A May 23 report prepared by the human rights organization Justicia y Paz stated that fascistic paramilitary groups, which operate in concert with the far-right and US-backed regime of Colombian President Ivan Duque, have created torture sites and mass graves in an attempt to suppress protests in the city of Cali, which has been the epicenter of continuing countrywide demonstrations.

The post Torture sites and mass graves reported in Colombia appeared first on PopularResistance.Org.

External feed Read More at the Source: https://popularresistance.org/torture-sites-and-mass-graves-reported-in-colombia/

 2021-06-01  Comments Off on PopularResistance.Org – Torture sites and mass graves reported in Colombia
Jun 012021
 

Postgres has had “JSON” support for nearly 10 years now. I put JSON in quotes because well, 10 years ago when we announced JSON support we kinda cheated. We validated JSON was valid and then put it into a standard text field. Two years later in 2014 with Postgres 9.4 we got more proper JSON support with the JSONB datatype. My colleague @will likes to state that the B stands for better. In Postgres 14, the JSONB support is indeed getting way better. I’ll get into this small but pretty incredible change in Postgres 14 in just a minute, first though it is worth some summary disclaimer on the difference between JSON and JSONB. JSON still exists…

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

 2021-06-01  Comments Off on Planet PostgreSQL – Craig Kerstiens: Better JSON in Postgres with PostgreSQL 14
Jun 012021
 

Today’s links

Canadian telco monopolists run the show: The CRTC just put Teksavvy out of business.

Google cheats on location privacy: Part of the attribution con.

The antitrust case against Prime: The dotted line to higher prices.

This day in history: 2006, 2010, 2016, 2020

Colophon: Recent publications, upcoming/recent appearances, current writing projects, current reading

Canadian telco monopolists run the show (permalink)
If there’s one lesson you’d hope governments would take away from the pandemic and the lockdown, it’s that good internet policy – universal access at fair prices, managed in the public interest – is a prerequisite for all good policy.
Canada didn’t get the memo.
Last week, the CRTC – Canada’s telecoms regulator – released its long-awaited decision on the wholesale prices paid…

External feed Read More at the Source: https://pluralistic.net/2021/06/01/you-are-here/

 2021-06-01  Comments Off on Pluralistic: Daily links from Cory Doctorow – Pluralistic: 01 Jun 2021
Jun 012021
 

In addition to the GCC 9.4 release today, the GCC Steering Committee announced today that they are dropping their long-running policy of requiring copyright assignment to the Free Software Foundation for all code contributions…

External feed Read More at the Source: https://www.phoronix.com/scan.php?page=news_item&px=GCC-Drops-FSF-CA

 2021-06-01  Comments Off on Phoronix – GCC To No Longer Require Copyright Assignment To The Free Software Foundation