why drop database so slow

DROP DATABASE

@charlotte don't forget to tip your server

the reason seems to be that i’m currently flooding another database with very expensive requests

which uh a drop database should be really quick tho? just delete a folder or sth

currently it is running a very expensive autovacuum due to said expensive requests lol

@qugalet thanks postgresql

@charlotte OH: “Remember to always tip your servers!”

@charlotte manual DROP_TABLE;

@charlotte "always tip your server"

@charlotte Oh I dislike it when the server crashes like that.

@charlotte pleroma 👍

@Houl server needed to run a single user mastodon instance

@charlotte don't boot the server when it's crashed

@patterfloof i think this server is getting booted

well at least parts of it

@charlotte This photo full of pain.

@charlotte This is why we can’t have nice tables.

@charlotte 🙀 ​

@charlotte This happened all by itself, right?

@charlotte Pending transactions or whatever they are called in english?

@razzlom @charlotte Your server is DOWN!

@charlotte oh my fucking god...

@charlotte please CW gore thanks /j

@charlotte this hurt

@charlotte haha I have seen this image before with the caption « remember to tip your server »

@charlotte
My heart skipped a bit

@charlotte looks more like a blade frame with 2 blade servers on the right and disk arrays on the right.

@charlotte OMG !!

@charlotte All that stuff should be inside the big box, right ? 😁

@charlotte Server is down.

@charlotte

LET THE SERVERS HIT THE FLOOR
LET THE SERVERS HIT THE FLOOR

@charlotte
[Later] "I told you one of the rack wheels was locked!"

@charlotte Defragmentation required.

@charlotte oh no the data's in bits! 😏

@charlotte
😱😖

@charlotte Linus was here.

@charlotte REPAIR TABLES

@charlotte This is what happens when you don't pay your servers minimum wage

@charlotte read error on /dev/sda

@charlotte I don't think that this is an NCSS approved form of storage media sanitisation 👀

@charlotte Don't forget to tip your servers.

@charlotte Bobby Tables at it again... he's such a kidder.

(seriously though this hurts to look at 😂)

@charlotte
Must have been a forklift hit it. Or 2 IT admins fought next to it & bumped it.

@charlotte So, that's what happened to Little Bobby Tables after he grew up and started to work in IT ☠️

@charlotte
Ohhh not good

@charlotte I said "FAIL OVER," not "FALL OVER!"

@charlotte Someone did a zoolander.

@charlotte A bad case of fragmentation.

@charlotte I hope they remembered that RAID is not a backup.

@charlotte 🤣🤣

@charlotte if ever a CW was needed :-)

@argenis @charlotte `fsck -a -y` didn't work! Oh noes!

@charlotte My favourite caption for this picture is "Don't forget to tip your server!"

@charlotte 😢

@charlotte NSFW

@charlotte And THAT is why you don't run SELECT * FROM * queries on unindexed tables, kids.

(J. Walter Leatherman)

#valuablelifelessons

@charlotte

;
😢⚰️🙏🏼;

@charlotte haha I love this for so many reasons. 1st It's not mine. 2nd Many of the comments are just hilarious.

@charlotte this makes my teeth hurt.

@charlotte

@charlotte

Bird server site, Monday, 8 o'clock, Musk entering server room. All that's left.

@charlotte Little Bobby Tables visits the Metaverse

@charlotte
In Spanish we say "Se cayó el servidor/sistema" (roughly "The server/system fell down") when any system is slow or not responding. This is the physical representation of that phrase...=)

@charlotte So that is what happened a couple of times. That makes sense why I couldn't connect to DB

@charlotte there wasn't even a table :O

@charlotte that's one way to shard data

@billstewart415 @charlotte this was the reply I was looking for. No! Little Bobby Tables! What did you do!

@charlotte Don't forget to tip your server

@charlotte

@charlotte

My entire body cringes, looking at that photo.

@charlotte do a barrel roll!

@charlotte Linus, is it you? #ltt

@charlotte rate limiters and stabilizers need not apply…

@charlotte When SQL queries are taken a wee bit too far. 😂

@charlotte also called "unplanned backup policies & reliability testing in prod"

@charlotte I mean... it *might* still have parity? :P

@charlotte the puns in the comments are giving me life 😆

@charlotte Please don't say the Virtual Tape Library was hosted on the same rack as the database server.

@charlotte OH GOD NO.

@charlotte EXPLAIN

@charlotte big oof

@charlotte this made my day. Not the breakage. But the comment cracked me up.

@charlotte core dumped

@charlotte SELECT disk FROM floor;

@charlotte 😳😳 Aie aie

@charlotte
Raid degraded

@charlotte
@leyrer

Whereas

DROP TABLE

Hover to show content

@climagic @charlotte Remember to back up or your feet will hurt 😉

@charlotte 😱

@charlotte Sir, the server crashed...

@charlotte 😳😂

@charlotte Don't forget to tip your server!

@charlotte ouch, my bits!

@charlotte Reminds me of that episode where Data needed to plug all the isolinear chips back in...

@charlotte

@tilton

"Hi, help desk? Our server is down... No I don't think switching it off and back on would be of any help..."

@charlotte assez efficace j'ai l'impression :)

@charlotte once upon a time I stood in a datacenter waiting for an e10k to shut down. It broke through the raised floor almost toppeling over and we did our best to support it. Once it shut down we we able to pull drives … to get her lighter. No customers hurt in this incident, second one took over.

@tabtwo honestly if the structural integrity of a building is at the risk it would be fine to just pull the plug

@charlotte there wasn’t any danger for the persons

@charlotte

@tabtwo @charlotte That reminds me of a post I read online a while back about how some idiots filled multiple racks with full out bladecentres... and the datacenter floor collapsed

@NeoFox @charlotte something like that, yes

@charlotte So that's what RAID10 is for.

@charlotte ooof. It got RAIDed

@charlotte at first this caused me great consternation but then i thought: oh no a mixtape website's storage servers oh no what a shame

@charlotte I don't think Data is gonna get all those Iso linear chips back in there this time.

@charlotte @chris It’s one way to test the backup restore procedures.

@charlotte need Data to put everything back in

@guysoft @charlotte @qugalet @Polychrome So what RAID level was that anyway

@charlotte That just hurts my soul...

@charlotte That server went out on the razz and has fallen over insensate, emptying it's contents onto the floor with abandon...

@charlotte defragmentation?