Page All:
Page 1
PostgreSQL is a powerful true SQL engine that is fully open source and competes with MySQL and all the way up to Oracle and the like. They have just released version 8.3 which promises speed increases. While Version 4 will only be written for MySQL, the DB abstraction layer can handle others. PostgreSQL looks better and better. I think it is time I really checked it out.
PostgreSQL is a powerful true SQL engine that is fully open source and competes with MySQL and all the way up to Oracle and the like. They have just released version 8.3 which promises speed increases. While Version 4 will only be written for MySQL, the DB abstraction layer can handle others. PostgreSQL looks better and better. I think it is time I really checked it out.
Quote
Version 8.3 provides greater consistency of performance than previous versions, ensuring that every user can depend on the same high performance demonstrated in recent benchmarks for every transaction, whether in peak hours or not, seven days a week, 52 weeks per year. Major performance enhancements include:
* Heap Only Tuples (HOT), which eliminate up to 3/4 of the maintenance overhead of frequently updated tables
* Spread checkpoints and background writer autotuning, which reduce the impact of checkpoints on response times
* Asynchronous commit option for much faster response times on some transactions
These changes also significantly accelerate transaction processing throughput, between 5% and 30%, depending on the workload.