|
|
Tech Specs
|
|
|
|
System Requirements
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
|
|
