@vyruss is donating a signed copy of his "PostgreSQL Mistakes and How to Avoid Them", and @intrbiz put a special edition "electric elephant" in the prize pool - truly, what's keeping you from testing the beta release?! 😅
@giggls refreshing the collation version will make the warning go away. However you might have index corruption, from the underlying changes to the collation.
If you have any type of indexes on text columns, you should reindex those. To rebuild the index aligned with the new collation rules. Then you can refresh the collation version.
@neil your home range, or somewhere else?
@nixCraft also, nothing screams you're employer is awful, than being happy at finding a good candidate under market rate.
A few times, hiring, I found great people who asked for way less than they deserved. I told the company to offer them what they're worth.
The good places did, and we ended up with a great person who felt valued.
The bad places did not, and we ended up with a great person who ended up feeling cheated.
I wish more companies could understand treating people well is good.
@nixCraft getting a job somewhere else. Has universally been my fastest way to a raise, and what I've tended to advise people to do. Employers rarely demonstrate loyalty these days.
I've seen many employers spend more on recruiting a replacement rather than giving a colleague a raise.
The best I once saw, after 3/4 of the team had quit, got a job offer (for comparable pay) then turned around and demanded a 3x raise or they'd leave, leaving the company with no-one in the team, it worked.
@andypiper @codepope @hackwimbledon oh :(
Had many nice conversations with him at PostgreSQL events, will be missed.
PGDay UK returns on September 9, and we’re proud to be a Partner-level sponsor. Bruce Momjian, PostgreSQL Evangelist at EDB, will take the stage with his talk “Future Postgres Challenges.” Devrim Gunduz, Bilge Ince, and Floor Drees support the event as volunteers: https://2025.pgday.uk/
The night before, we’re also sponsoring the very first Apache Iceberg™ Europe Meetup at Paddington Central. Miles Richardson will be speaking about the WarehousePG project: https://lu.ma/u042b0vw @postgresuk
@dick_turpin being against things is what the Torry party has done for the last decade.
Do you have complex orchestration issues that you'd like to solve with Podman? Quadlets are now native to Podman and they let you do that! Find out how here! https://blog.podman.io/2025/08/level-up-your-container-game-unified-quadlet-management-is-now-natively-in-podman/ #podman #OpenSource
@amd hmm, but is that not writing 4 copies of the data to the underlying PVs. Which seems a more likely cause of slow performance than it being thin.
An analysis of Github's recent studies on "AI" agents for software development
(Original title: Jussi Pakkanen: Let's properly analyze an AI article for once)
https://nibblestew.blogspot.com/2025/08/lets-properly-analyze-ai-article-for.html
@amd I've not experienced significant performance dip due to thinpool on my setup. Wouldn't have thought the slightly extra metadata of thin provisioning would cause a bit impact.
iostat -mx would be worth a look at to see if your saturating the disk IO and where.
When you say raid 1, do you mean raid 10? 4 disks in a mirror seems odd.
Is the slow IO inside a VM or on the host?
@mntmn looks like it's using an RCA socket with a switched terminal and wiring the switched part to the other channel. I'm guessing, but looks like it's trying to operate in mono if only one RCA plug is plugged in, but in stereo if both are plugged in.
🎤 Our first confirmed speakers for PGConf.EU 2025 are now live!
Check out who’s already on the lineup 👉 https://www.postgresql.eu/events/pgconfeu2025/sessions/
We’re updating the list as more speakers confirm, so keep an eye on it — and once all sessions are locked in, we’ll be publishing the full conference programme.
Exciting things ahead — stay tuned!
#PGConfEU #PostgreSQL #Postgres
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk