PostgreSQL for Solaris is a high-performance database server, designed
for high-volume and/or large-database tasks, and compiled and optimized
for the Solaris platform. The system requirements, below, primarily
reflect the requirements for Solaris. If your system can run Solaris, it
is likely to be sufficient to run PostgreSQL for Solaris.
Hardware Requirements
Memory
Minimum of 256 MB of physical RAM
Hard Disk
Minimum of 2 GB of available hard drive space
Processor
For SPARC processors, 250-MHz minimum
For x64- or x86-based processors, 120-MHz minimum
Database Size
Small
Minimum 100MB in order to accommodate a large number of system tables
Large
Effectively infinite in size
Tables of up to 18 quadrillion rows with up to 1 gigabyte of data per row
Up to 5 TB to ensure performance with large tables
Transaction Performance
Concurrency
500 to 1,000 concurrent active connections
Up to 50,000 concurrent application users (depending on hardware)
Throughput
Sustains 2,000 to 20,000 transactions per second (depending on hardware)
Memory Usage
Small
Runs on any system which is capable of running Solaris
Large
Performs well with 2GB to 8GB of RAM
Can utilize up to 128 GB RAM with high-performance or large-database applications
SQL Support
SQL Support
Supports most of the ANSI SQL92 specification and some advanced
functionality in SQL99 and SQL03
Runs SQL-standard application with little to no adjustment
Supports all join and subquery types -- can execute 50-line queries
Supports stored procedures, schema, triggers, domains, and interval data
Driver Support
Driver Support
Includes C and standards-compliant JDBC drivers
Drivers for ODBC, PHP, Perl, C++, Python, Ruby, .NET, and other languages are available from the PostgreSQL community
