1.ceramics926

u/1.ceramics926@kopitalk.net
7 posts · 19 comments

Recent posts

Recent comments

I'm happily back with normal load levels, PieFed is once again quite snappy.

Do some of us just keep the instance private from here on out after this experience?

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.

I checked the memory records from last night and I do see the VPS hover in the 90% range, finally spiking to 98.9% when something probably finally choked.

Thanks for teaching me something new!

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.

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

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.

“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.”

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