Skip site navigation (1) Skip section navigation (2)

Release Notes Overview

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Release Notes Overview
Date: 2007-10-05 09:01:38
Message-ID: 1191574898.4223.300.camel@ebony.site (view raw or flat)
Thread:
Lists: pgsql-hackers
My suggested edit of the Overview section of the Release Notes. The
emphasis is on user-noticeable features, so some of the major internal
changes are lower down the list. Some items have been removed or placed
below the performance features.


New data types for SQL/XML, enum and uuid types

Updateable Cursors, plus support in PL/pgSQL. PostgreSQL now supports
all major items of Core SQL:2003 compatibility.

Full text Search is now a built-in feature, so .... is easier/better

Asynchronous Commit allows some transactions to commit faster than
others, offering a trade-off between performance and durability for
specific transaction types only

Database Size reductions both per-row and per-field

Additional security features: GSSAPI/SSPI and easier to implement
security-definer functions using per function SET parameters

New ORDER BY ... NULLS FIRST/LAST option and matching support for
indexes allows easier migration of applications from other RDBMS

Better scalability and more consistent response times come from
systematic removal of internal contention points within the server

Performance improvements in many important workloads

- update-intensive workloads now avoid index inserts via a new internal
mechanism known as HOT, plus multiple concurrent auto-vacuum processes
maintain the database more consistently

- initial data loads now avoid writing WAL, plus all data loads use less
CPU than previously

- large table scans by optimising cache usage and allowing multiple
synchronous scans to reuse the same data, avoiding I/O

- short read-only transactions give reduced costs and higher scalability
using lazy transactionid assignment 

Tracking of internal activity has many additional features, improving
your ability to design, manage and maintain the database

Self-adjusting background writer helps write-intensive workloads

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com


Responses

pgsql-hackers by date

Next:From: Gregory StarkDate: 2007-10-05 10:24:04
Subject: Re: Release Notes Overview
Previous:From: Tatsuo IshiiDate: 2007-10-05 08:21:03
Subject: Re: default_text_search_config

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group