PostgreSQL 8.3 designed for better speed
Programmers behind the PostgreSQL project released the new version 8.3 of the open-source database software Monday, saying they've boosted improved performance 5 percent to 30 percent and added several useful features.
One of the performance improvements comes from a technology called heap-optimized tables, which reduces the amount of effort a computer must expend updating the frequently changed elements of the database. Other improvements reduce the penalty of taking periodic snapshots of the database and an speed some transactions though an "asynchronous commit" ability, the organization said.
Other features include "synchronized scan," which makes data … Read more