one more thing... what does this error mean?
psql:tst3.sql:21: ERROR: plpgsql: cache lookup from pg_proc failed
thanks.. I will try creating that function. :)
- Greg
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 12, 2000 8:24 AM
To: Gregory Krasnow
Cc: Bruce Momjian; [EMAIL PROTECTED]
Subject: Re: [GENERAL] backend running out of memory in v7.0
Gregory Krasnow
Gregory Krasnow <[EMAIL PROTECTED]> writes:
> typical query produced from this product (I didn't write the piece that
> creates the queries, and I know that the queries could definitely be
> optimized):
> SELECT cms_users.usr_id
> FROM cms_usr_prof, cms_usr_incenvalue, cms_opt_in, cms_users,
>
ND (cms_users.usr_id= cms_opt_in.usr_id)
AND usr_glob_sub=1
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 11, 2000 6:21 PM
To: Bruce Momjian
Cc: Gregory Krasnow; [EMAIL PROTECTED]
Subject: Re: [GENERAL] backend running out of memory in v7.0
Bruce Momjian <
LOTS of time looking over and over for infinite loops,
Problems/Leaks in the scripts, etc. I found nothing.
> From: "Gregory Krasnow" <[EMAIL PROTECTED]>
> Date: Thu, 11 May 2000 17:58:21 -0700
> To: [EMAIL PROTECTED]
> Subject: RE: [GENERAL] backend running out of me
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> stack size (kbytes) 8192
>
> I bet this is the problem.
Nah, 8 meg stack should be fine --- that's the same configuration I run.
>> On Thu, 11 May 2000, Gregory Krasnow wrote:
I know that there were some
Original Message-
> From: The Hermit Hacker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 4:32 PM
> To: Gregory Krasnow
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] backend running out of memory in v7.0
>
>
> On Thu, 11 May 2000, Gregory Krasnow wrote:
Hermit Hacker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 4:32 PM
> To: Gregory Krasnow
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] backend running out of memory in v7.0
>
>
> On Thu, 11 May 2000, Gregory Krasnow wrote:
>
> > I know that there were so
unlimited
>
> thanks... I thought of that as well.
>
> - Greg
>
> -Original Message-
> From: The Hermit Hacker [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 11, 2000 4:32 PM
> To: Gregory Krasnow
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENER
: Gregory Krasnow
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] backend running out of memory in v7.0
On Thu, 11 May 2000, Gregory Krasnow wrote:
> I know that there were some issues with many AND/OR joins in
> PostgreSQL 6.5 which caused the backend process to run out of memory.
> I
On Thu, 11 May 2000, Gregory Krasnow wrote:
> I know that there were some issues with many AND/OR joins in
> PostgreSQL 6.5 which caused the backend process to run out of memory.
> I am still having some similar issues in PostgreSQL 7.0. I was
> wondering if there some recommended configuratio
11 matches
Mail list logo
