3 ms·
When I was a beginner I once accidentally created an Amazon RDS Postgres database backed by tape. I was so flustered by how slow it was until I saw the setting.
by Waterluvian 4y ago
When I was a beginner I once accidentally created an Amazon RDS Postgres database backed by tape. I was so flustered by how slow it was until I saw the setting.
- ufo 4y agoLol! I'm curious how slow it got... How slow are we talking about here?
- Waterluvian 4y agoA non-cached GET for a single database record was like 7 seconds. It was especially scary because I was in the “I have no idea what I’m doing, and I’m at a tech startup and am a team of one.”
- lazide 4y agoStill too fast for it to have been tape hah. If it was on tape, it would have taken minutes
- emmjay_ 4y agoI'm not sure how this is possible. You can only choose EBS backed storage for RDS Postgres. Do you mean 'magnetic' storage? That's not tape.
- Waterluvian 4y agoIt could be tape. But perhaps you’re right that it’s HDDs I guess? I assumed most of their normal storage is hard disk and not SSD. They’ve got a lot. Edit: I checked. You’re 100% right. Well now my anecdote sucks! :) And now, seven years later, I’m back to start on wondering why it was so brutally slow.
- emmjay_ 4y agoHeh. It's not tape. :) If you provisioned a really small amount of GP2, you can run out of I/O credits pretty quickly and get throttled to baseline performance (and it used to be 7 times the storage provisioned, or some such, and now it's 100 IOPS). That's brutally slow for a working database.
- oogali 4y agoIt's not possible. GP was likely confused by the different types of hard drives (standard, sc1, st1), and assumed it was tape or was incorrectly told by someone else that it was tape. If I squint hard enough, the only viable explanation I could come up with is GP said "I created the database using the st1 storage type" and someone responded "st!? As in a UNIX SCSI tape drive[0]?" 0: https://man7.org/linux/man-pages/man4/st.4.html https://man7.org/linux/man-pages/man4/st.4.html
- SoftTalker 4y agoWhen I was in school, the professor of our operating systems class told us about a virtual memory project implementation that had the swapfile on tape. It worked, but it wasn't anything you'd actually ever use.
- Waterluvian 4y agoWhen I was 9 or 10 I once set virtual memory on my Macintosh to live in a 44MB SCSI cartridge drive. It was brutally slow.