4
votes
1answer
2k views

Understanding block sizes

My question targets Postgres, but answers might just be good enough coming from any database background. Are my assumptions correct: Disks have a fixed block size? RAID controller can have a ...
3
votes
3answers
3k views

Can I specify a different disk for a specific MySQL table?

I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...