What type of database would be faster to perform a SELECT?

Question

PostgreSQL

There is a data set (about 5k lines), the data is structured.

It is necessary to select a database that will make a selection from the database at maximum speed according to certain criteria (WHERE in SQL). No links or anything, just one table. What type of database will work faster in this case?

I consider mongo as NoSQL, postgresql as SQL

Answer 1

Anything will work at a good speed on this scale.
Take postgres

Answer 2

"Standard" relational databases are suitable for most tasks and should be considered the default.
All other "exotics", such as mongi, can only be considered if, for some reason, relational databases do not satisfy. Often NoSQL is used together with SQL, but for different subtasks.
Today, the NoSQL approach is being promoted too strongly and not very deservedly.