On 3 Feb 2006 at 7:10, Karl Hakimian wrote: > 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.
I'll try tuning things if you can get the data to me, or give me access to the database. It's not always indexes. Sometimes it's more along the lines of queries or vacuum. We've long known that the PosgreSQL module can be improved. What we've been lacking is a starting point where we can actually measure the improvement. -- Dan Langille : http://www.langille.org/ BSDCan - The Technical BSD Conference - http://www.bsdcan.org/ ------------------------------------------------------- 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
