PostgreSQL Version 8.2+ is an open source object-relational database management program (like the MySQL) that can be downloaded at www.postgresql.org (for Windows 32 Platform). The package includes an administration tool for database management. Application Programming Interfaces (Perl Driver, JDBC Driver,C++ API,.Net Data Provider, Driver, OLE-DB Driver, Next generation interface for TCL, Tcl binding library, Tcl interface to PostgreSQL written in Tcl, ODBC Driver, Python interface for PostgreSQL, OpenOffice.org PostgreSQL Driver) are also available in the site which is used for the data processing management. PostgreSQL has an added functionality, the POSTGIS, which can be used in Geographical Information System (G.I.S.) applications.
The following are the facts of PostgreSQL:
Maximum size for a database: unlimited (32 TB databases exist)
Maximum size for a table: 32 TB
Maximum size for a row: 400 GB
Maximum size for a field: 1 GB
Maximum number of rows in a table: unlimited
Maximum number of columns in a table: 250-1600 depending on column types
Maximum number of indexes on a table: unlimited
Source:http://www.postgresql.org/docs/faqs.FAQ.html
April 7th, 2008 at 2:17 pm
thanks, this info’s very helpful…