Version 9.1 delivers several features which users have been requesting for

years, removing roadblocks to deploying new or ported applications on
PostgreSQL. These include:
* Synchronous Replication: enable high-availability with consistency across
  multiple servers
* Per-Column Collations: support linguistically-correct sorting per database,
  table or column.
* Unlogged Tables: greatly improves performance for ephemeral data

Our community of contributors innovates with cutting-edge features. Version 9.1
includes several which are new to the database industry, such as:
* K-Nearest-Neighbor Indexing: index on "distance" for faster location and text
  search queries
* Serializable Snapshot Isolation: keeps concurrent transactions consistent
  without blocking, using "true serializability"
* Writeable Common Table Expressions: execute complex multi-stage data updates
  in a single query
* Security-Enhanced Postgres: deploy military-grade security and Mandatory
  Access Control

3 files changed, 53 insertions, 0 deletions

diff --git a/databases/postgresql91-monitoring/DESCR b/databases/postgresql91-monitoring/DESCR
new file mode 100644
index 00000000000..a7d6d0fd016
--- /dev/null
+++ b/databases/postgresql91-monitoring/DESCR
@@ -0,0 +1,19 @@
+This package provides the following PostgreSQL modules:
+  - auto_explain
+  - pg_buffercache
+  - pg_stat_statements
+  - pgstattuple
+
+The "auto_explain" module provides a means for logging execution
+plans of slow statements automatically, without having to run
+EXPLAIN(7) by hand. This is especially helpful for tracking down
+un-optimized queries in large applications.
+
+The "pg_buffercache" module provides a means for examining what's
+happening in the shared buffer cache in real time.
+
+The "pg_stat_statements" module provides a means for tracking
+execution statistics of all SQL statements executed by a server.
+
+The "pgstattuple" module provides various functions to obtain
+tuple-level statistics.
diff --git a/databases/postgresql91-monitoring/Makefile b/databases/postgresql91-monitoring/Makefile
new file mode 100644
index 00000000000..b5c384f7f1d
--- /dev/null
+++ b/databases/postgresql91-monitoring/Makefile
@@ -0,0 +1,20 @@
+# $NetBSD: Makefile,v 1.1.1.1 2011/09/15 08:30:47 adam Exp $
+
+PKGNAME=	${DISTNAME:C/-/91-monitoring-/}
+COMMENT=	PostgreSQL monitoring tools
+
+PKG_DESTDIR_SUPPORT=	user-destdir
+
+DEPENDS+=	postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server
+
+.include "../../databases/postgresql91/Makefile.common"
+
+BUILD_MAKE_FLAGS=	PGXS=1
+
+BUILD_DIRS+=		contrib/auto_explain
+BUILD_DIRS+=		contrib/pg_buffercache
+BUILD_DIRS+=		contrib/pg_stat_statements
+BUILD_DIRS+=		contrib/pgstattuple
+
+.include "../../databases/postgresql91-client/buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql91-monitoring/PLIST b/databases/postgresql91-monitoring/PLIST
new file mode 100644
index 00000000000..c1ad22b11b3
--- /dev/null
+++ b/databases/postgresql91-monitoring/PLIST
@@ -0,0 +1,14 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2011/09/15 08:30:47 adam Exp $
+lib/postgresql/auto_explain.so
+lib/postgresql/pg_buffercache.so
+lib/postgresql/pg_stat_statements.so
+lib/postgresql/pgstattuple.so
+share/postgresql/extension/pg_buffercache--1.0.sql
+share/postgresql/extension/pg_buffercache--unpackaged--1.0.sql
+share/postgresql/extension/pg_buffercache.control
+share/postgresql/extension/pg_stat_statements--1.0.sql
+share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
+share/postgresql/extension/pg_stat_statements.control
+share/postgresql/extension/pgstattuple--1.0.sql
+share/postgresql/extension/pgstattuple--unpackaged--1.0.sql
+share/postgresql/extension/pgstattuple.control