Database design and PostgreSQL question?

Question

PostgreSQL

Good day.
I need to store movies, cartoons, series, music, etc. in the database.
All these entities I consider as Media. There are quite a few other tables associated with media.
I read several articles (one of them is on Habré ) that it’s bad to store all media types in one table and it’s better to make one common Media table and many other tables that are associated with a 1 to 1 Media relationship.
Question: in postgresql, how much I know there is table inheritance. If you make a Media table and inherit tables for specific media types from it, would that be a good approach? In what case will queries be faster if there is a lot of data?

Answer 1

Need to aim for 3nf

Answer 2

Why use a DB when you can use the xfs filesystem? Metadata can be stored in the DB, of course. Why produce dry things? What's the problem with keeping everything in one table?
How are you going to make backups? It is necessary to save more important information first, for example, a list of users ... Or are you going to use several databases?