On Thu, Mar 10, 2005 at 04:39:25PM +0100, Tom Ivar Helbekkmo said: > Walt Reed <[EMAIL PROTECTED]> writes: > > > I would expect 8.x to be faster that 7.x, but I didn't see anything > > in the release notes that would indicate a 1 to 2 orders of > > magnitude performance increase. > > A few points concerning PostgreSQL and performance: > > - Each of the latest releases has improved performance quite a bit. > > - Out of the box, it is tuned for minimal resource use, and dismal > performance. It really needs to be tuned. Check out Josh Berkus's > web site, <http://www.powerpostgresql.com/>, for hints and tips. > > - Nothing helps much if your schema and your queries are suboptimal. > Think about how your data is used, consider what indexes you need, > rewrite slow queries to be smarter (use EXPLAIN). > > - Did I mention you need to tune the database system to your needs?
You snipped out my paragraph where I mentioned tuning the DB itself, queries, and schema. I have no doubt that 8.x is faster than 7.x, but I did not find any reports from people claiming a 10X performance boost. I didn't look hard, but I did look. I'll look into installing 8.x and see if we can rerun the tests. _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
