Table of Contents

History

• PostgreSQL History
• [PostgreSQL on Solaris History]

FAQ

• PostgreSQL on Solaris FAQ

Appliances

• PostgreSQL 8.3  Appliance

Introduction to PostgreSQL on Solaris

• Different versions available on Solaris
• Solaris Role Based Access Control - postgres
• PostgreSQL and SMF
• Clients of PostgreSQL on Solaris

Planning Deployment of PostgreSQL on Solaris

• Performance Planning for Deployment
  • Disk layout considerations
  • Response time Vs Throughput
• Virtualization Planning for Deployment
  • [Zones]
  • [LDoms]
  • [Solaris xVM]
• High Availability Planning for Deployment
  • [Warm Standby]
  • [Sun Cluster HA for PostgreSQL]
• Scalability Planning for Deployment
  • Replication
  • Table Partition
• Upgrade Planning for Deployment
  • Current Practice for Upgrade
• Other Considerations
  • ZFS

Administering PostgreSQL on Solaris

• Upgrading From Older Version Of PostgreSQL
• Managing PostgreSQL Services on Solaris
  • PostgreSQL and SMF integration
  • Running/Configuring PostgreSQL using SMF Commands
  • Running PostgreSQL in Solaris Containers
• [Populating/Migrating Data to PostgreSQL on Solaris]
  • [Loading Data in PostgreSQL on Solaris]
  • [Creating/Migrating Stored Procedures/Functions in PostgreSQL on Solaris]
  • [Creating Triggers in PostgreSQL on Solaris]
• [Backup and Restore with PostgreSQL on Solaris]
  • [pg_dump and pg_restore]
  • [ZFS Snapshot/Clone]
  • [Hot Backup with ZFS Snapshot/Clone with PITR]

High Availability, Replication, Warm Standby for PostgreSQL on Solaris

• [Sun Cluster and PostgreSQL ]
• [slony and PostgreSQL ]
• [pgBouncer and PostgreSQL ]

Demos and Examples of PostgreSQL on Solaris

• Example of very simple  PostgreSQL Cluster setup
• Example of PostgreSQL Cluster setup in Solaris Zones
• Example of a Complex Well Performing with Replication/Warm Standby with HA Setup

Developing Applications with PostgreSQL on Solaris

• Using PostgreSQL with Scripting Languages
  • PHP
  • Ruby
  • Python
  • Perl
  • PL/pgSQL
• Using PostgreSQL with Java (JDBC driver)
• Using PostgreSQL with C/C++
• Using Netbeans as IDE with PostgreSQL
  • Supported Versions
  • DB Navigation
  • Wizard Based Import/Export
• [Using Glassfish as Application Server with PostgreSQL]
  • [Create PostgreSQL Resource Pool]
  • [Create JDBC Resource]
    • [Using PostgreSQL JDBC Role - An Example BPEL Process]

JDBC

• Bundled in Solaris 10 8/07 /usr/postgres/8.2/jdbc/postgresql.jar
• PostgreSQL JDBC Driver
• Statement Caching Driver Wrapper for PostgreSQL JDBC

[Developing Appliances with PostgreSQL on Solaris]

• [Creating appliances with PostgreSQL using OpenSolaris framework]
• [End User Appliances with PostgreSQL database on OpenSolaris]

Tuning PostgreSQL on Solaris

• PostgreSQL server Tuning (postgresql.conf)
• Filesystem Tuning
  • [ZFS]
  • [UFS]
  • [QFS]

[DTrace and PostgreSQL]

• [DTrace and PostgreSQL ]
• PostgreSQL DTrace Users Guide

Zones

• Zones and PostgreSQL
• PostgreSQL in Solaris 10 Zones

[Sun Cluster & Open Cluster]

• [Sun Cluster and PostgreSQL ]
• Sun Cluster Data Services for PostgreSQL

Performance Monitoring PostgreSQL on Solaris

• What to Monitor?
• Using PostgreSQL System Tables and view
• Using Solaris tools
  • Using prstat with pargs to figure out session problems
  • Using iostat to figure out hot disks
• [Using DTrace Probes]
  • User-Level Statically Defined DTrace Probes in PostgreSQL
    • LWLock Probes
    • Transaction Probes
  • Other Useful DTrace scripts for PostgreSQL
• [Using Sun Studio Performance Analyzer]
• Problem Determination

Performance Tuning and Recommend Layouts

• [Peformance Tunings for PostgreSQL on Solaris ]
• PostgreSQL Tuning from SolarisInternals

Recommended Layouts/Best Practices

• [Recommended Layouts for PostgreSQL on Solaris ]

Benchmarks and Workloads with PostgreSQL

• EAStress
• TPC-E
• TPC-H
• SysBench

Published Benchmarks

• SpecJAppServer2004 benchmarks using PostgreSQL on Solaris

Bottlenecks Possible with PostgreSQL

• ProcArray Structure
• CLOG Buffers
• WALWriteLock
• WALInsertLock

[Other tasks with PostgreSQL on Solaris]

References

• PostgreSQL.org Documentation
• docs.sun.com Documentation

[Glossary]

[Index]

Articles

• PostgreSQL in OpenSolaris - Zdenek Kotala, July 2007

Blog Entries

• PostgreSQL 8.3beta1 on Solaris

Blogs on PostgreSQL

• Josh Berkus:      http://blogs.ittoolbox.com/database/soup
• Jignesh Shah:    http://blogs.sun.com/jkshah
• Tom Daly:            http://blogs.sun.com/tomdaly
• Robert Lor:          http://blogs.sun.com/robertlor/
• Glenn Fawcett:    http://blogs.sun.com/glennf/category/Postgres

PostgreSQL for Solaris

• http://sun.com/postgresql
• PostgreSQL on Solaris
• Building your own PostgreSQL

PostgreSQL:

• http://www.postgresql.org

OpenSolaris databases community

• http://www.opensolaris.org/os/community/databases/

Ask Questions on OpenSolaris Database Forum

• http://www.opensolaris.org/jive/forum.jspa?forumID=175

Feedback

• postgresql-feedback@sun.com