Spyke

Replies

canada

Comment on

Protesters fear ‘American-style’ 2-tiered health care is coming to Canada

Asked for a response to the protestors concerns about Bill 11 and the future of private health care in Alberta, Maddison McKee, press secretary for Alberta Minister of Primary and Preventative Health Services Adriana LaGrange, sent Global News an email that lashed out at Friends of Medicare, calling the organization “a political advocacy group governed by the province’s public-sector unions. They routinely spread misinformation and hyperbolic predictions, so it’s misleading to cite them as if they were impartial experts.”

“Their talking points are always the same: they compare Alberta’s common-sense changes to cherry-picked facts from other countries and a theoretical version of Canadian Medicare, rather than the real system patients experience every day,” added McKee.

This is the same UCP dream team that brought us CorruptCare, and they still refuse to step aside to let a proper investigation take its course. Danielle Smith continues to consolidate power into more private parties who are beholden to her and public coffers. She promises so long as she's here, the money will continue to flow, and she expects political support in return.

Comment on

New bill would let New Yorkers hang solar panels from windows

Reply in thread

Giving residents the option to rely on their own solar power and manage power consumption sounds like a win. As far as I can tell, other countries haven't set themselves on fire either. Last I checked smokers popping cigarettes into planters do quite a good job on their own.

https://www.dw.com/en/boom-small-solar-devices-plugged-into-household-sockets-german-energy-transition/a-75022163

canada

Comment on

"If you think the CCP will treat foreigners better than its own people when it extends its power over you, please think again:" Rights activist warns Canada over risks of trade with China -- [Opinion]

I appreciate the information here. I just wish to point out if we're talking about human displacement, Canada and the US can be accused of the same upon its indigenous populations, the practice of slavery, and a history of segregation/apartheid.

If one is highlighting this mechanism/issue to discuss the real costs of industry and economic development, I think it's a worthy issue. Were there better alternatives to what the European and Western powers ended up doing to others? I certainly hope so.

But if one frames this so called displacement as a moral issue to pretend a better or superior position, then this is delusional. I'd rather defer to the UN Declaration of Human Rights and suggest that the world should aspire to do more.

climate

Comment on

Bill Gates Says Climate Change ‘Will Not Lead to Humanity’s Demise’

Agreed. Gates has gone on record to say that AI will take over most jobs. He's on a campaign to show he's "onside". But I think this is a worrying sign that the Americans grow weary of the AI tech bubble. The US don't have much going for them for this bubble to buttress the fall of the AI bubble burst.

Crypto's got features, but it's most endearing feature is to move money when it's generally not supposed to move - either by fraud or otherwise. In the event of a market correction, crypto will only accelerate the exit of wealth from the US.

https://www.msn.com/en-us/news/technology/bill-gates-warns-ai-will-take-over-most-jobs-and-leave-humans-working-just-two-days-a-week/ar-AA1P8HCv

canada

Comment on

Edmonton sees record increase in frostbite amputations, despite innovative treatment

Reply in thread

“What we need in this city is not just affordable housing, as in housing that's 80 per cent of market value,” said Strikwerda. “We need social housing that's geared to income.”

I took a drive downtown yesterday during the day. Homeless are laid down on the concrete sidewalks with blankets. There were some nasty -20C and worse days in Edmonton. The UCP don't care, neither did EPS under McFee, and I point out the silence from Edmonton Police on the subject.

There are many reasons why people may not go to a shelter even when space is available, such as feeling unsafe due to past experience.

A controversial practice in both Edmonton and Calgary has been to dismantle tents and homeless encampments. Both cities confirmed that policy will continue this winter, citing safety concerns.

“When the city responds to an encampment, we do not simply ‘take it down,’” said a statement from a City of Calgary spokesperson.

“Our teams engage directly with occupants and ensure they are offered safe, warm alternatives before any structure is removed. No encampment is dismantled without providing support and connections to appropriate services and shelter options. The goal is always to reduce harm, prevent exposure to the elements, and create a safer outcome than if someone remained outdoors.”

Comment on

RE: Kopitalk Piefed Website Inaccessible

Reply in thread

I tried searching around for tips on settings and stumbled on this.

https://dbadataverse.com/tech/postgresql/2025/02/postgresql-configuration-parameters-best-practices-for-performance-tuning

Following those general tips then for a 4Gb RAM VPS

Step 1: Reserved 25% for the OS: 3Gb

Step 2: Adjust Shared Buffer to 25% to 40% of RAM (After Reserve): About 1Gb

Step 3: Adjust Working Memory for Concurrent Users: I adjusted for 150 Concurrent Users and about half of 4Gb. So 15Mb

150*15 = 2,250

Result: VPS RAM usage went down from the 80% range to around the 50% range.

Comment on

RE: Kopitalk Piefed Website Inaccessible

Reply in thread

Thanks! VPS has 4GB ram.

I have these defaults for the postgres

services:

  db:
    shm_size: 2gb
    image: postgres:17
    restart: unless-stopped
    user: "1000:1000"
    env_file:
     - ./.env.docker
    command:
      - postgres
      # Memory
      - -c
      - shared_buffers=1GB
      - -c
      - effective_cache_size=3GB
      - -c
      - work_mem=32MB
      - -c
      - maintenance_work_mem=256MB

      # WAL / checkpoints
      - -c
      - checkpoint_completion_target=0.9
      - -c
      - wal_buffers=16MB
      - -c
      - max_wal_size=4GB
      - -c
      - min_wal_size=1GB

      # Query planner
      - -c
      - random_page_cost=1.1
      - -c
      - effective_io_concurrency=200

      # Connections
      - -c
      - max_connections=150
      - -c
      - jit=off
    volumes:
     - ./pgdata:/var/lib/postgresql/data
    networks:
      - pf_network