[geeks] MySQL question

[Phil Stracchino]

On Mon, May 24, 2004 at 11:50:45PM -0400, Patrick Giagnocavo +1.717.201.3366 wrote:
> On Mon, May 24, 2004 at 11:16:11PM -0400, Phil Stracchino wrote:
> > On Mon, May 24, 2004 at 10:29:46PM -0400, Patrick Giagnocavo +1.717.201.3366 wrote:
> > > if you have a chance, please do look at Postgresql.  Provided your app
> > > can use it, it is a much better choice in many ways.  apologies if
> > > this idea has already been put forth.
> > 
> > This is another of those religious issues.  We (as in the Bacula
> > project) have discovered that the Bacula database schema has to be
> > substantially changed for installations using PostgreSQL, because
> > certain operations that Bacula uses heavily are at least ten times
> > slower on PostgreSQL than on MySQL.
> 
> Would love to hear more about this and see some sample code.  Maybe I
> could run it past some PG gurus I know and they could suggest
> something.

If you dig through the archives of bacula-devel on lists.sourceforge.net
from about, oh, three or four weeks ago, maybe six, you should be able
to find the discussion.  I seem to remember it had something to do with
an index on a foreign key, but I'll admit I wasn't paying too close
attention to that thread.  Operations like building lists were taking
minutes on MySQL and 11 hours on pgSQL.

I'll try and find the details for you if you're interested.


> Are you doing anything that resembles a tree or parent/child node
> relationship?  I know a screaming fast implementation that is open
> source for PG you could lift for your own use.

Uh, I think it did have to do with building trees ....  I'll check.  If
you have got a big code speedup, I'm sure Kern would be glad to have it.


-- 
 .*********  Fight Back!  It may not be just YOUR life at risk.  *********.
 : phil stracchino : unix ronin : renaissance man : mystic zen biker geek :
 :  alaric at caerllewys.net|phil-stracchino at earthlink.net|phil at novylen.net  :
 :   2000 CBR929RR, 1991 VFR750F3 (foully murdered), 1986 VF500F (sold)   :
 :    Linux Now!   ...Because friends don't let friends use Microsoft.    :