-1
What are the restrictions on using Postgresql database in my commercial C application#?
What’s the size limit? And simultaneous connections? What problems can I face, in the matter of networking with other machines?
2 answers
4
Licensing restrictions:
None, the source is open.
Maximum size for a database:
unlimited (there are databases of 32 TB)
Maximum size for a table:
32 TB
Maximum length of a line:
1,6 TB
Maximum size for a field:
1 GB
Maximum number of rows in a table:
boundless
Maximum number of columns in a table:
250-1600, depending on column types
Maximum number of indexes in a table:
boundless
Maximum number of connections:
by default, 100 simultaneous connections, but can be configured in postgresql.conf
Source: https://www.postgresql.org/message-id/42C3C382.5020108%40cineca.it
4
Licensing is quiet and can do anything.
There are no major restrictions, and it can run well. Or not. Because usually what makes the most difference is the person knowing what they’re doing, that’s much harder. For most applications to choose something that is not ideal is a minor problem. Because in general the wrong choice is made by general ignorance and this will cause a much bigger problem.
Studying the basics to be able to evaluate all points is something much more important than knowing some specific information. What is the point of knowing who discovered Brazil, whether this information can be false, incomplete or confused, or even be irrelevant, or not knowing why you need to know this?
There are no connection limitations in the software other than by configuration. Of course there is a practical limit, but it depends on a number of factors. And that doesn’t matter much, because in enterprise applications it doesn’t come close and in web applications it will only come if it was all architected wrong.
The maximum size of data is theoretical and should not worry, because if one makes an application that needs so much will be a professional who dominates the subject a lot. There are specific limitations that in almost everything is theoretical, again because if you overcome is doing something wrong. Everything has a solution. The most important limit is the number of columns in a table that is 250 in some cases, in practice the limit can be 1600 depending on the types used, and if you need more than 250 has a great chance of being doing something wrong, and has how to get around. Another is the limit of 1GB per column, which is quiet for almost everything.
Has a OS response that still maintains the described limits.
There is no limit to network connection with other machines, only client-server databases are limited in this. Obviously there is a practical limit
The decision of which database to use and adopted model goes through other things. It’s not because you know this that you’ll make the right decision as to which database to use.
I was going to talk forever look at the documentation to see these things, this is the most important to know what to do, but in this particular case they took, which shows that the product started to get more marketer and that’s a bad sign, this is a project that was very dear to engineering.
Browser other questions tagged postgresql connection
You are not signed in. Login or sign up in order to post.
In my view this question is valid, so much so that it has already been answered. Funny how people vote to close for anything, without even commenting with who opened the question.
– Flávio Granato
I fully agree with Flávio Granato. I believe that if the question was asked, or is duplicated as is the term used, it is because perhaps it has not reached the goal of those who doubt on the subject. It’s okay that there are a lot of rules about how to ask the questions, only sometimes it’s such a simple question that it doesn’t need as much information. It is a pity that this happens, it ends up discouraging people from using Stackoverflow, I have several friends and colleagues who have abandoned for this reason.
– Rafa
The question has to be so functional that one doesn’t have to ask the question ...
– Motta