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.
I'll look into it later. =) maybe I'll roll a Chrome extension
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...
Anyway, on the drafts thing, I also keep a plain text backup manually. Thankfully I don't need to do that often. If I did, I'd probably be looking for a better solution than Notepad
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 HAVE MORE THAN 8 LAC RECORDS AND COULM NAME IS "OP PTC" NOW I CREATED ONE MORE COULMN HAVEING NAME "NET PTCL" I WANT TO COPY THE RECORD OF 1ST COULMN IN NEW COLOM, HOW CAN I DO THAT>
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='||(...
Hell ya, then we'll return to Evil Corp, walk in with your employee id, open source Direct X and run away like the stealth ninjas we are retiring to a tropical flip-flop friendly island.
@JoeObbish Well, to be fair (Letterkenny reference).... the line of code right before the check says "This should never happen, but if something is awfully wrong avoid being stuck here."
@sp_BlitzErik Haha you know Pedro is under Amit and neither are my boss... but I appreciate it
@sp_BlitzErik So, it looks like it's a generic signaling mechanism for mirroring events of pretty much everything lol
seems a good bit around the log, but also contains updates or other items too - again as a signal something should happen
It'd be hard to tell if it's causing a problem or not. I'd say if it were really high then there is a lot of traffic... that's about all I could glean from that event being high...
If the wait time is long then something is processing fast enough
maybe too much cpu, spinlocks, slow IO, etc.,
it's too broad of a wait
... It's cool, I talk to myself all day... I answer myself too...
I like hypervisors and all, but seriously people need to stop thinking of VMs as a magical unicorn poop they can slather on things to make them better.
@JoeObbish I've... dislocated both shoulders, been hit by 3 trucks, tore my left pectoral, have had more than 15 concussions, and yet I still do it.. I have faith in you, come back...
@sp_BlitzErik Felt like something was wrong with my heart or something... couldn't breathe right, left side hurt, etc., ugh
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
Yeahh that's going to be fun to troubleshoot, I be that's what did it too. Without writing to the database. It must have corrupted itself on routine maintenance
@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
We used to LAN that, I was no longer allowed to play after an incident where I killed everyone on the other team, by myself, and captured their flag multiple times. I became a ref after that.
i HAVE MORE THAN 8 LAC RECORDS AND COULM NAME IS "OP PTC" NOW I CREATED ONE MORE COULMN HAVEING NAME "NET PTCL" I WANT TO COPY THE RECORD OF 1ST COULMN IN NEW COLOM, HOW CAN I DO THAT>
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='||(...
