PostgreSQL

Getting Started

• Get Solaris 10 or Solaris Express Developer Edition with PostgreSQL 8.2 
• How to Configure and Run PostgreSQL on Solaris 
• PostgreSQL Online Documentation 
• PostgreSQL Support & Services from Sun
• Building your own PostgreSQL on OpenSolaris

Performance and Monitoring

• PostgreSQL Monitor - A Demo
• PostgreSQL 8.3beta performance testing on Solaris
• PostgreSQL performance bootcamp for Oracle DBAs
• PGstatspack - Getting at Postgres performance data

PostgreSQL and Solaris DTrace, ZFS, Containers, SMF, etc.

• PostgreSQL in the OpenSolaris OS
• Dynamic Tracing of PostgreSQL using DTrace
• Introducing user-level DTrace probes in PostgreSQL
• Starting PostgreSQL using SMF

Database Migration

• Switching Databases from MySQL to PostgreSQL 8.2

Benchmarks

• Sun Java (TM) Systems Application Server 9.0 Platform Edition with Postgres 8.2 - 778.14 SPECjAppServer2004 JOPS@Standard
• Sun Java (TM) Systems Application SErver 9.1 Platform Edition with PostgreSQL 8.2 - 813.73 SPECjAppServer2004 JOPS@Standard 
• Sun SPECjAppServer2004 result (using Glassfish and PostgreSQL) compared with HP (using Oracle) 

    Disclosure Statement
    Sun Fire X4200 (4 chips, 8 cores) - 813.73 SPECjAppServer2004 JOPS@Standard 
    Sun Fire X4200 (6 chips, 12 cores) - 778.14 SPECjAppServer2004 JOPS@Standard 
    SPEC, SPECjAppServer reg tm of Standard Performance Evaluation Corporation. All results from www.spec.org as of July 23,2007