Version 6.5 (Released June 1999)
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() ...
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.