Re: [SQL] JOIN index/sequential select problem

Поиск
Список
Период
Сортировка
От Ole Gjerde
Тема Re: [SQL] JOIN index/sequential select problem
Дата
Msg-id Pine.LNX.4.05.9905130224540.1232-100000@snowman.icebox.org
обсуждение исходный текст
Ответ на Re: [SQL] JOIN index/sequential select problem  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] JOIN index/sequential select problem
Следующее
От: Henrik Steffen
Дата:
Сообщение: TEXT, VARCHAR(50) or CHAR(50)?