I've been stung by the Question-saving multiple times. I've lost a ton of work on that. To that point, I actually do write externally and save here. My solution really is notepad here, I'd just rather not and I wonder what others less technical do.

This is now complete for answers and new questions.
If you start asking a question, but do not successfully submit, you will see your last saved question draft the next time you visit the ask a question page.
If you start answering a particular question, but do not successfully submit, you will...

Implicit vs Explicit JOIN Syntax
It's called a SQL-89 Implicit (Cross) Join. You should prefer the more modern Explicit syntax. In PostgreSQL the Implicit syntax has a different precedent, and it currently serves as an optimization fence. What you actually want is a CROSS JOIN and because you're...

I'm trying to read a JSON API with the Postgres COPY FROM COMMAND command.
When I call
COPY _temp FROM PROGRAM 'curl -uri "https://url"';
it works fine but the API has paging and I need to loop through multiple calls.
When I call it like this:
_command := 'curl -uri "https://url?&page='||(...

I was walking to a customer site in Hawaii and was crossing the street... had the same pit of the stomach feeling like I did when I was hit on my motorcycle... looked to my right - hello Toyota pickup..

ran the red light and slammed me into the side walk from half way on the road

@JoeObbish wow, you've managed ot get high spinlocks on the suspend queue... I'd say the spinlock is fine, your workload - however - has a ton of suspended threads on their schedulers and should be looked at