Re: [SQL] JOIN index/sequential select problem - Mailing list pgsql-sql

From Ole Gjerde
Subject Re: [SQL] JOIN index/sequential select problem
Date
Msg-id Pine.LNX.4.05.9905130224540.1232-100000@snowman.icebox.org
Whole thread Raw
In response to Re: [SQL] JOIN index/sequential select problem  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] JOIN index/sequential select problem
Next
From: Henrik Steffen
Date:
Subject: TEXT, VARCHAR(50) or CHAR(50)?