From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
Cc: | PJ <af(dot)gourmet(at)videotron(dot)ca>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: migration problem |
Date: | 2008-05-17 16:27:39 |
Message-ID: | 27010.1211041659@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> writes:
> That function hits the database repeatedly. If the problem is in fact
> with a database query that it's generating you need to determine which
> one. You could step through the function with a PHP debugger or just
> insert log/printing statements in the function so you can see its progress.
Even easier, turn on query logging (log_statement = all), run the
function, and then look in the postmaster log to see what happened.
7.3 is a long time back, and I wouldn't be surprised if you are hitting
some compatibility issues in trying to make the jump to 8.3 in one step.
It's hard to tell what though ... I don't find that PHP code very
readable.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2008-05-17 18:25:19 | Re: writing a function without installing a language |
Previous Message | iSteve | 2008-05-17 13:43:27 | tsearch2 on-demand dictionary loading & using functions in tsearch2 |