Some days ago we received a post from in the spanish forum [1] asking for any indication to tune the performance of Openbravo running over a PostgreSQL database. By the moment we have not had the necessity of tunning a PostgreSQL database, but following its indications (thank you "jepg") I found pgbench. pgbench is a program useful to make a database benchmarking that can be run many times with different variations of clients and transactions looking for the best configuration.
I have added this information to the Performance Tips for PostgreSQL in the wiki [2]. I have also found several interesting pages with explanations about how pgbench works, configuration examples and performance tips ( [3], [4], [5], [6] and [7] ). I hope you find this information interesting. Carlos Romero Openbravo Team [1] https://sourceforge.net/forum/forum.php?thread_id=1924132&forum_id=650010 [2] http://wiki.openbravo.com/wiki/index.php/Performance_and_Security_Tips#Optimize_your_performance_in_PostgreSQL [3] http://edoceo.com/liber/db-postgresql-performance [4] http://sitening.com/seo-tools/postgresql-benchmark/ [5] http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm [6] http://www.revsys.com/writings/postgresql-performance.html [7] http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Openbravo-development-announce mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-development-announce
