si
Administrator
PostgreSQL 7.4
PERFORMANCE
Several major performance enhancements have been added in version 7.4, enabling PostgreSQL to match or exceed the speed of other enterprise database systems. These include:
Hash aggregation in memory to make data warehousing and OLAP queries up to 20 times faster;
Improvements in subquery handling by the planner resulting in up to 400% speed increases in some complex queries;
New script to set more reasonable postgresql.conf defaults for shared buffers, yielding better "out of the box" performance;
New wire protocol (version 3) increases the speed of data transfers;
Enhanced implementation of functional indexes allows better indexing on custom data types and composite fields;
HIGH AVAILABILITY
Expansion of PostgreSQL's Free Space Map disk management feature to support continuous index maintenance is the last "piece of the puzzle" in providing 24/7/365 uptime for PostgreSQL databases. The many hardware solutions vendors who include PostgreSQL as the embedded database in their applications may now eliminate the need for any data locking or downtime in their applications.
OPTERON SUPPORT
PostgreSQL is now optimized on the AMD Opteron, thanks to the work of the University of Massachusetts at Amherst, adding to the family of proven 64-bit platforms which includes HP/Compaq, Alpha, Sun UltraSPARC, MIPS, PA-RISC, and RS6000*. 64-bit platforms are an emerging class of high-performance computing, with greater power and scalability needed for enterprise systems.
FULL TEXT INDEXING
PostgreSQL's TSearch module now includes a ranked preference system, making TSearch equal to or better than many full text indexing solutions offered by other RDBMSs.
REPLICATION
PostgreSQL Inc. has contributed their eRServer Java-based replication solution to the PostgreSQL community. eRServer provides a highly scalable, battle-tested replication option significantly more powerful than previously available Open Source solutions. For more information, see the release on PostgreSQL Inc.'s web site.
Подробности:
http://www.postgresql.org/presskit/en/presskit74.php
PERFORMANCE
Several major performance enhancements have been added in version 7.4, enabling PostgreSQL to match or exceed the speed of other enterprise database systems. These include:
Hash aggregation in memory to make data warehousing and OLAP queries up to 20 times faster;
Improvements in subquery handling by the planner resulting in up to 400% speed increases in some complex queries;
New script to set more reasonable postgresql.conf defaults for shared buffers, yielding better "out of the box" performance;
New wire protocol (version 3) increases the speed of data transfers;
Enhanced implementation of functional indexes allows better indexing on custom data types and composite fields;
HIGH AVAILABILITY
Expansion of PostgreSQL's Free Space Map disk management feature to support continuous index maintenance is the last "piece of the puzzle" in providing 24/7/365 uptime for PostgreSQL databases. The many hardware solutions vendors who include PostgreSQL as the embedded database in their applications may now eliminate the need for any data locking or downtime in their applications.
OPTERON SUPPORT
PostgreSQL is now optimized on the AMD Opteron, thanks to the work of the University of Massachusetts at Amherst, adding to the family of proven 64-bit platforms which includes HP/Compaq, Alpha, Sun UltraSPARC, MIPS, PA-RISC, and RS6000*. 64-bit platforms are an emerging class of high-performance computing, with greater power and scalability needed for enterprise systems.
FULL TEXT INDEXING
PostgreSQL's TSearch module now includes a ranked preference system, making TSearch equal to or better than many full text indexing solutions offered by other RDBMSs.
REPLICATION
PostgreSQL Inc. has contributed their eRServer Java-based replication solution to the PostgreSQL community. eRServer provides a highly scalable, battle-tested replication option significantly more powerful than previously available Open Source solutions. For more information, see the release on PostgreSQL Inc.'s web site.
Подробности:
http://www.postgresql.org/presskit/en/presskit74.php