What is Postgresql?
PostgreSQL (post-gress-Q-L) is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. This system runs on the all major operating systems, including UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), Windows, and Linux. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It also includes most of the SQL data types, including CHAR, VARCHAR, DATE, INTERVAL, INTEGER, NUMERIC, BOOLEAN and TIMESTAMP. It supports storage of binary large objects, including pictures, sounds, or video. The native programming interfaces of this system include for C/C++, Net, Perl, Python, Java, Ruby, Tcl, ODBC, among others, and expectational database. It can be configured through configuration files.
Postgresql’s configuration file
PostgreSQL.conf include files or directories can be used to logically separate portions of the database configuration, rather than having a single large PostgreSQL.conf file. Consider that a company that has two database servers, each database with a different amount of limit memory.
There are active post-gress-Q-L instances in production environments that manage many terabytes of data, as well as clusters managing petabytes. Some general PostgreSQL limits are included in the table below.
|Maximum Database Size||Unlimited|
|Maximum Table Size||32 TB|
|Maximum Row Size||1.6 TB|
|Maximum Field Size||1 GB|
|Maximum Rows per Table||Unlimited|
|Maximum Columns per Table||250 – 1600 depending on column types|
|Maximum Indexes per Table||Unlimited|
Command to access PostgreSQL.conf file