tag:blogger.com,1999:blog-21289662.post116884236988079510..comments2023-09-26T01:39:21.395-07:00Comments on Bioinformatics: real-world postgresql vs mysql benchmarkbrentphttp://www.blogger.com/profile/12236821145627337774noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-21289662.post-1170277428456376812007-01-31T13:03:00.000-08:002007-01-31T13:03:00.000-08:00josh thanks for the tips. i'll try those out. the ...josh<BR/> thanks for the tips. i'll try those out. the ram is 12G, i believe.<BR/>also, i asked on #postgresql if there was an example postgresql.conf file for a more modern machine, but noone was able to point me to one. i think it would be a nice addition to your site to have some links to some rough suggested conf files a la: postgresql_2GRAM.conf, _8GRAM.conf, _multCPU.conf, etc.<BR/>for folks like me who are just running around in the dark. <BR/><BR/>anonymous<BR/>agreed and noted. and i'll look into this preloading of indicies. i know nothing about that.brentphttps://www.blogger.com/profile/12236821145627337774noreply@blogger.comtag:blogger.com,1999:blog-21289662.post-1170274458295342382007-01-31T12:14:00.000-08:002007-01-31T12:14:00.000-08:00Brent,I need to update that article. A few things...Brent,<BR/><BR/>I need to update that article. A few things to set:<BR/><BR/>1) wal_buffers should be set to 128. We'll probably make this the default in the future.<BR/><BR/>2) 10000 seems low for effective_cache_size. How much RAM do you have?<BR/><BR/>--Josh BerkusAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-21289662.post-1170264758052650912007-01-31T09:32:00.000-08:002007-01-31T09:32:00.000-08:00You should post your MySQL config along with the s...You should post your MySQL config along with the size of the indexes for your tables in question. <BR/><BR/>MySQL requires a lot of tuning to be very efficient (both on the server as in the queris you send). I am not surprised that a default install leads to those results.<BR/><BR/>It would be most beneficial to have the EXPLAIN output of the query you are trying to run.<BR/><BR/>Things to look out for with MySQL are to make sure indexes can be preloaded/kept in memory for maximum efficiency.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21289662.post-1170208446158635212007-01-30T17:54:00.000-08:002007-01-30T17:54:00.000-08:00Thank you.Thank you.Anonymousnoreply@blogger.com