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