October 2001
Beginner to intermediate
400 pages
7h 45m
English
Multiversion Concurrency Control (MVCC)—Removed older table-level locking mechanisms.
Hot backups from pg_dump—Capability to backup/restore while database is operational.
Numeric data type—Added a new NUMERIC data type.
Temporary tables—Temporary tables are guaranteed to have unique names within a database session and are destroyed on session exit.
Ports—Expand ports list, including WinNT/ix86 and NetBSD/arm32.
New SQL features—Added CASE, INTERSECT, and EXCEPT statement support. There is a new LIMIT/OFFSET, SET TRANSACTION ISOLATION LEVEL, and SELECT … FOR UPDATE, and an improved LOCK TABLE command.
Added vacuumdb utility.
Using EXPLAIN, all indices used.
New pg_dump table output format.
Added string min()/max() ...
Read now
Unlock full access