D
D
Dmitry Krapivin2019-05-23 16:46:20
PostgreSQL
Dmitry Krapivin, 2019-05-23 16:46:20

What is the maximum amount of stored files or users simultaneously uploading a file should be in order to knock down a PostgreSQL database?

The database stores formalized data about cars and files for them (also in the database) (pdf, doc, jpg, png, zip, etc.).
I want to know the "pain" threshold of the PostgreSQL database. Judging by your practice, please tell me:

  1. Judging by the practice of your work, how many files need to be stored in the database in order to knock down (work slowed down) the PostgreSQL database?
  2. Judging by the practice of your work, how many simultaneous users do you need, for example, trying to unload the same or different files from the database at the same time in order to knock down (work slowed down) the PostgreSQL database?

Note:
Types of stored files: pdf, doc, jpg, dwg, zip, etc.;
Basic file operations: writing and reading;
Volume of 1 file: mostly 100 Kb - 100 MB;
The total volume of all files can grow from 10 GB to 80 GB and more up to 1 TB within 1 year;
Number of users: from 10-30

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
ky0, 2019-05-23
@ky0

The database stores formalized data about cars and files for them

Take it away, this is an architecture that has no right to life.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question