Increase PostgreSQL Performance without Hardware change
By PierreReynes on Jun 30, 2009
The BluePrints article “Optimizing PostgreSQL Application Performance with Solaris Dynamic Tracing” demonstrates, using multiple examples, how DTrace can be used to observe, analyse and fix PostgreSQL performance bottlenecks. The paper shows for example how to analyze and fix slow queries or optimize the buffer cache usage, all that live, without rebooting, recompiling, or even restarting the application. Download this paper and improve your database performance without changing the hardware.
Sun BluePrints articles are free whitepapers, written by engineers, for engineers. Don't miss out, stay up to date and join the Sun BluePrint Community on Facebook or subscribe to the Sun BluePrints Community RSS Feed.