I don’t follow Lemmy closely, but I believe they one day aspire to have a feature to combine similar links together to follow the discussion easier. Piefed does have this feature already and it’s great.

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

Isn’t that basically ICE and the selective enforcement of the law as demonstrated in Epstein?

Are you sure you haven’t been exposed to so much violence that you’ve been convinced to redefine it?

Some, including myself, already are of the opinion that the US is an autocracy because its billionaire class has effectively taken over the reigns. Whatever checks there are don’t actually balance out the billionaires with the rest of greater America.

deleted by creator

I have not paid attention to the Diablo series for a while now, but I was tempted to drop back in with D2 for quality of life improvements and new content.

I have D4 sitting around, I just didn’t have the same feeling to try again.

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.

Dengue is slowly creeping north as far as Colorado. Are you sure no one wants to make it?

https://insideclimatenews.org/news/10112025/colorado-invasive-dengue-fever-mosquito/

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

Poetic and miserable, I may not be able to bear looking at a slushy machine the same way.

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