On Thu, Feb 02, 2006 at 07:21:48PM -0500, Dan Langille wrote: > As the author of the Bacula PostgreSQL module, I'm curious as to why > you would go in that direction. Most people tend to move to > PostgreSQL from MySQL. > > Is there something missing you need?
I'm also considering switching from postgres to mysql on my home machine. While I prefer almost everything about postgres, I'm having trouble getting the performance I need out of it. I have read quite a bit about tuning postgres and still can't seem to get thing the way I want. My current problem has to do with selecting files for a recover utility that I'm working on. I want to be able to query the database for the contents of a single directory at a time, this will allow for a much faster restore when you want to only grab a file or two from a very large backup. I had to add a couple of indexes to the File table and I had things working pretty well until I realized I needed one more bit of data from the Filename table. At this point, postgres went from returning the data within a second to taking 30 or so seconds to do it. All of my queries are using indexes and nothing returned from the explain command shows me anything that I can see as a problem. I have run the equivalent query against mysql on a much larger database and it returns in less than a second. BTW One of the things I really like about postgres is the fact that coming up with this query was pretty straight forward using standard sql references. The changes needed to make the query work with mysql just about drive me nuts. -- Karl Hakimian [EMAIL PROTECTED] ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
