| From: | "Arjen van der Meijden" <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> | 
|---|---|
| To: | "'Nigel J(dot) Andrews'" <nandrews(at)investsystems(dot)co(dot)uk>, "'shreedhar'" <shreedhar(at)lucidindia(dot)net> | 
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'Postgre General'" <pgsql-general(at)postgresql(dot)org>, "'Postgre Admin'" <pgsql-admin(at)postgresql(dot)org> | 
| Subject: | Re: [GENERAL] Fatal error: Allowed memory size of 8388608 | 
| Date: | 2003-09-24 09:52:36 | 
| Message-ID: | 000b01c38281$99318fa0$3ac15e91@acm | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin pgsql-general | 
> Nigel J. Andrews wrote:
>
> On Wed, 24 Sep 2003, shreedhar wrote:
> 
> > I am using PHP4 as client side.
> 
> In that case what about this setting in php.ini:
> 
> memory_limit = 8M      ; Maximum amount of memory a script 
> may consume (8MB)
But before you change that, you may want to dive into the code that
consumes so much memory. Perhaps you just don't reuse/free enough memory
or have a bug in your code that causes it to loop too often.
But as said, it has nothing to do with postgres and is a pure php error
and you may want to continue your quest on the php mailing lists or
their pretty decent manual.
Regards,
Arjen
> > ----- Original Message -----
> > From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> > To: "shreedhar" <shreedhar(at)lucidindia(dot)net>
> > Cc: "Postgre General" <pgsql-general(at)postgresql(dot)org>; 
> "Postgre Admin" 
> > <pgsql-admin(at)postgresql(dot)org>
> > Sent: Wednesday, September 24, 2003 10:44 AM
> > Subject: Re: [ADMIN] Fatal error: Allowed memory size of 
> 8388608 bytes 
> > exhausted
> > 
> > 
> > > "shreedhar" <shreedhar(at)lucidindia(dot)net> writes:
> > > > If I try to insert I got the following error as
> > > > Fatal error: Allowed memory size of 8388608 bytes 
> exhausted (tried 
> > > > to allocate 79 bytes)
> > >
> > > There is not, and never has been, any error message of 
> that wording 
> > > in the PG backend.  You must be looking at some 
> client-side failure.  
> > > But since you didn't tell us what client-side code you're using, 
> > > it's hard to say more than that...
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2003-09-24 10:26:13 | Re: export data from excel to postges | 
| Previous Message | Hornyak Laszlo | 2003-09-24 08:00:12 | Re: postgres 6.2 vacuum | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maurizio Faini | 2003-09-24 10:49:13 | Re: GET LAST ID INSERT | 
| Previous Message | Ian Harding | 2003-09-24 08:31:20 | Re: pltcl problem |