Re: [SQL] JOIN index/sequential select problem

On Thu, 13 May 1999, Bruce Momjian wrote:
> > gprof says:
> >   %   cumulative   self              self     total
> >  time   seconds   seconds    calls  us/call  us/call  name
> > 100.00      0.01     0.01        3  3333.33  3333.33  ValidatePgVersion
> Yikes.  ValidatePGVersion.  Seems you are in a loop in there somehow.  I
> bet you have a terrible mismatch somewhere.

I think you can ignore that line.  I ran it again and that wasn't there.
It looked identical otherwise however.  I timed it this time, and it took
13 minutes.
For some reason, gprof is somewhat messed up not showing timings.  I've
tried a few things and done some searching.  This seems to be a fairly
typical problem, but I haven't found any working solutions yet.
Maybe the # of times the functions are being called will tell you guys
something.
Any ideas on the gprof?

Thanks,
Ole Gjerde