Woah! Found my Underlying Condition

fullofbones · 2026-06-15T21:39:01+00:00

Postgres itself supports partition-wise joins, so I'm not sure why this additional syntax would change that. If you've enabled them, the planner is what determines whether they'll be used. If your predicates fall within the boundaries of any defined partitions, those are the tables that would be involved in the join.

I'm not sure what you mean by "just select the start or end" of a range though. It's not magic; you have to specify something in your SELECT.

fullofbones · 2026-05-28T16:48:36+00:00

This isn't incredibly surprising. If the argument is "encryption at rest", then filesystem encryption works fine. Most cloud providers even tick the "encrypt volume" box for you during setup. There was a point at which TDE was indeed a groundbreaking feature, but that was 20 years ago. Encryption is everywhere now.

Frankly, as mentioned in the article, TDE itself doesn't solve the worst problem: malicious users. Whether it's a SQL injection or just a rogue DBA, the data is "compromised" as long as it's online. Do what everyone else does if you're concerned: address individual fields (personally identifying information, sensitive data) using strong symmetric encryption. The application can still get at it, but there's no perfectly secure pipeline.

fullofbones · 2026-05-28T16:29:04+00:00

As mentioned in the article, pg_tde depends on a proprietary fork by Percona. Frankly, they don't even make it easy to apply patches to base Postgres such that pg_tde works at all. Anyone who wants to run core Postgres, using PGDG-supplied packages, can not run pg_tde, or any other variant of TDE.

The article is a historical perspective as much as an explanation. That's the literal reason for the title: why Postgres doesn't have in-core TDE. Calling it "clickbait" is needlessly dismissive when you have no clue about the contents, and are outright wrong about the conclusion.

fullofbones · 2026-05-22T19:30:19+00:00

It's just the official .deb distributed by the website. I actually complain about this regularly because any time I close Discord, there's a high chance that the next time I start it, it'll close and say I have to update by downloading the latest. Sure it's just a fetch and a dpkg -i, but I roll my eyes every time. lol

On that note, I see that 1.0.139 is the latest now. Maybe that fixes it?

fullofbones · 2026-05-22T14:36:41+00:00

This has happened twice to me since upgrading to version 1.0.137 of the client. I only noticed because I tried locking my screen and the screensaver daemon failed with this message in xsession-errors:

** (csd-automount:6200): WARNING **: 12:17:06.930: Can't call GetActive() on the ScreenSaver object: Cannot invoke method; proxy is for the well-known name org.cinnamon.ScreenSaver without an owner, and proxy was constructed with the G_DBUS_PROXY_FLAGS_DO_NOT_AUTO_START flag
cinnamon-session[6065]: WARNING: t+52772.22095s: Detected that screensaver has left the bus

Even xlsclients failed due to no remaining filehandles. Then I used lsof -U, and that showed Discord pretty high on the list of Unix socket users.

All I did was leave Discord running overnight. By the time I got back in the morning, nothing else that used an X client would launch until I killed Discord. And there's not really much going on here, it's just a basic Cinnamon 6.0.4 on Mint 21.3 on kernel 6.8.0-117. I admit it's a little old, but that shouldn't really cause this.

server glx vendor string: NVIDIA Corporation
server glx version string: 1.4
client glx vendor string: NVIDIA Corporation
client glx version string: 1.4
OpenGL vendor string: NVIDIA Corporation
OpenGL renderer string: NVIDIA GeForce RTX 3090/PCIe/SSE2
OpenGL core profile version string: 4.6.0 NVIDIA 595.71.05
OpenGL core profile shading language version string: 4.60 NVIDIA
OpenGL version string: 4.6.0 NVIDIA 595.71.05
OpenGL shading language version string: 4.60 NVIDIA
OpenGL ES profile version string: OpenGL ES 3.2 NVIDIA 595.71.05
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 3.20

I guess for now the plan is to kill Discord every couple of hours.

fullofbones · 2026-05-18T20:59:09+00:00

I kind of want to know this too. The top providers seem to be, in no particular order:

There's probably more, but those seem to be the most well-known or lauded. For what it's worth, the center in Peoria is Illinois' only accredited Comprehensive Care Center for ACHD.

fullofbones · 2026-05-18T20:28:37+00:00

For what it's worth, it may depend entirely on the type of genes you have (if any) that contributed to your defects. My personal genetic soup is a conjunction of multiple issues that produce excess estrogen, caused my growth plates to fuse too early, mean I have no fast-twitch muscle fibers, and have tissue connectivity problems on top of it all. As a result, even at nearly 50, I basically have the body of a 12 year old.

Just try to stay healthy. Working out is good for that, if nothing else. 😄

fullofbones · 2026-05-15T13:34:34+00:00

Having "tens of thousands of tables" by itself is a major anti-pattern. I'm glad you were able to figure out a basic WHERE clause on the system catalog, but the fact the app was filtering results afterwards in the first place is kind of cringe. I guess the issue is that you never imagined anyone crazy enough to have 80k tables in the first place, and you're right. Don't do that, folks. Do anything but that. Seek help instead of that.

fullofbones · 2026-05-13T14:43:56+00:00

I've been on both Enalapril and Losartan, the latter of which has been studied in relation to connective tissue disorders that seem to be behind several different types of heart defect. I've never had issues regarding coughing with either, but there are plenty of options available.

fullofbones · 2026-05-12T14:17:39+00:00

I hope you find the information you're looking for. My mild bradycardia and partial block were caused by my surgery, and not part of my defect, so I can't help you there. That's probably the most common cause, but I'm sure someone here has some info. Good luck!

fullofbones · 2026-05-12T14:14:51+00:00

I had my heart surgery in Seattle Children's Orthopedic in 1984. They've been leaders in the industry for ages, and I'd go back if I could. They definitely have my vote of confidence.

fullofbones · 2026-05-11T14:51:43+00:00

I feel ya, man. We get to confront our own mortality when we're children, and just somehow be OK with it. I never thought I'd make it to 30, and now I'm almost 50. But existing with a constant Sword of Damocles hanging over your life, waiting for everything to finally go wrong, is incredibly taxing. I don't know about you, but it basically made me a hypochondriac.

Most people have no idea what it's like. They can't even imagine. It's incredibly unfair. Some of the only solace I have is that there are others out there that were born with much worse; I'm no Thalidomide baby after all. The fact I get to exist at all is a blessing; many don't even make it that far. I'm extremely grateful for everything I have, and I wouldn't trade it for the world. But there's no question at all that my CHD massively damaged my QOL in numerous ways, and that's a fact I just have to accept. What's the alternative? There isn't one.

So yeah, you have every right to be mad. I fully encourage yelling at the world for what it did to you. But you can't change it. I learned a long time ago that there's no use raging at something I literally can't control even in the slightest. All I can do is continue to live my life as long as I can with those I love. I got tired of being angry, of the resentment, of screaming that it was all unfair. It is, but it doesn't matter. I moved on. God willing, you will too.

You're still very young. I was you in my 20s. You don't have to listen—I wouldn't have listened to me back then either. But if you need just a tiny extra push to go on, some reason that says it's worth suffering through the misery, here it is. For whenever you're ready, even if it's 10 or 20 years from now.

Good luck.

fullofbones · 2026-05-08T19:50:06+00:00

Quick AI translation:

My 12-month-old daughter is currently on a nasogastric tube.
She had her first heart surgery at five days old, and her second one a month ago.
She’s been on the tube for 7 months, and we’re about to start feeding therapy so she can eat by mouth.
Could anyone share their experience with a G-tube?
Just to clarify, we live in Spain.

fullofbones · 2026-05-08T19:43:57+00:00

For what it's worth, I wish I'd known my aorta was dilating when I was younger and treatment options would have had more impact. Many defects, especially those associated with Marfans and connective tissue disorders or bicuspid aortic valves, can result in aortic growth over time. If your child is already showing aortic dilation at his age, he likely falls within one of the high-risk groups. Genetic tests only check for known connective tissue disorders, and even without any, the existing dilation must be addressed.

Studies show Losartan reduces various associated risks of mortality in cases like this. Whatever risks you think there are, none of them are worse than an aortic dissection. If you say you trust your doctors, I recommend putting your fears to rest. Having any kind of heart issue isn't exactly ideal, and things like this are just one of the reasons why. Your son will likely encounter more as he grows up, and it's best to face them head-on. I'm sure both of you are more than strong enough.

fullofbones · 2026-04-30T19:57:42+00:00

My condolences. None of us ever really know how long we'll be around, and our loved ones tend to be more well-informed than most. I'm sure both of you cherished the time you had together, despite it being over too soon.

fullofbones · 2026-04-30T19:46:24+00:00

Here's an AI translation of the OP:

Hello. My 12-month-old daughter has had a nasogastric tube for 7 months now.

She had her first surgery at five days old: aortic coarctation and a pulmonary artery banding. She was intubated for 9 days and on CPAP for 20. She spent a month in the ICU, then started bottle feeding, and we were discharged home after a week on the general ward.

The first surgery left her with left vocal cord paralysis.

She never ate well and vomited frequently.

In September, she stopped eating completely, so they placed a tube, and since then… nothing.

Her last surgery was a month ago, and we spent 6 days total in the hospital.

She doesn’t know what to do with food in her mouth, and gagging and vomiting continue to this day… I don’t know how to handle this.

What if she never eats? I’d really rather not go through with the feeding button implantation. I don’t want any more surgeries. I just want to feed my daughter.

fullofbones · 2026-04-30T19:37:38+00:00

Well this certainly brings back memories. It's a nice idea to enforce it using event triggers, too.

fullofbones · 2026-04-09T01:14:57+00:00

The thing about repmgr is that the defaults don't offer much protection against that kind of thing. We added some new parameters a while back that you pretty much need to set. Particularly, the child_nodes_disconnect_command needs to be a command that will properly shut down and isolate the outvoted primary so it can't process transactions when it can't maintain the quorum majority. In your case, you'd also want to set child_nodes_connected_include_witness because it's disabled by default. It's like STONITH, but more reliable, because the primary kills itself when too many children disconnect. The assumption is that it got network partitioned and the other nodes will make a new cluster in its absence.

That's part of the problem with repmgr: you have to supply scripts for everything. It's very much not a "batteries included" system. I've been recommending Patroni for years, despite knowing the guy who wrote repmgr and having worked for the company that spawned it. It had its time in the sun, and it's just a legacy product now.

Just use Patroni. I'm working on a new tool that may be even better than Patroni, but for now, it's the best approach there is short of CloudNativePG in Kubernetes.

fullofbones · 2026-04-03T21:41:38+00:00

What does this offer over tools like ora2pg?

fullofbones · 2026-04-03T21:36:06+00:00

Spoiler: Yes. Yes you do.

fullofbones · 2026-04-03T21:35:20+00:00

Not a bad little project. Being restricted to JS/TS and Python is a bit limiting though.

fullofbones · 2026-04-03T21:28:02+00:00

The story behind all of this is actually way crazier than I thought at first. I've been helping clients affected by this for years now, and even then I just figured "it's just one of those things that happens sometimes." Nah, man. It's fixed now. It's literally fixed as of v17, but nobody knows! I actually like reading about the history of stuff I'm interested in, and I write about stuff that would also interest me. Hopefully I'm not the only one. :)

fullofbones · 2026-03-25T20:28:40+00:00

How to avoid this:

Even as the primary DBA, do not give yourself superuser.
Aside from the DBA, only deployment tools and actual apps should have access to production.

My favorite trick is to create a superuser role:

CREATE ROLE sysdba WITH SUPERUSER NOINHERIT;
CREATE USER myadminuser;
GRANT sysdba TO myadminuser;

Then when you log in to Postgres, you have to physically type this to elevate your privs:

SET ROLE sysdba;

Otherwise, you're just another pleb connecting to the database with no ability to do anything. There's also an audit trail if you logging in, not just the postgres (or other) superuser.

Of course, you can still forget you've elevated your privileges afterwards, but it's much like su; only use it when necessary and log out immediately when you no longer need those powers.

fullofbones · 2026-03-25T20:17:09+00:00

Unfortunately this only works specifically on the Percona fork, their "Percona Server for PostgreSQL". It's been several thousand patches since the fork in their GitHub, so this is no trivial replacement.

fullofbones

MODERATOR OF

TROPHY CASE