Fwd: WARNING: out of shared memory

cc: the -list this time


---------- Forwarded message ----------
From: Jaime Casanova <jcasanov@systemguards.com.ec>
Date: Thu, Jul 16, 2009 at 5:18 PM
Subject: Re: [BUGS] WARNING: out of shared memory
To: "Juan C. Aragon" <juan@keisercomputers.com>


it's better for you to always write to the list because there are more
people that can help and the most of them are more prepared than me :)

On Thu, Jul 16, 2009 at 5:05 PM, Juan C. Aragon<juan@keisercomputers.com> w=
rote:
> Yes, this is another server.
>
> There is 8GB of memory.
>
> max_connections =3D 100
>
> shared_buffers =3D 32MB
>

well, you are plenty of RAM and thats seems a default configuration...
you can raise it to something better like 2GB...
that doesn't explain the error, though... at least not to me

> It looks like this:
>
> 2009-07-16 16:53:20 WARNING: =C2=A0out of shared memory
> 2009-07-16 16:53:20 STATEMENT: =C2=A0INSERT INTO "public"."student_table"=
 (
> student_first_name,student_last_name,student_address,student_city,student=
_st
> ate,student_zip,student_phone,student_email,student_dob,student_status,sy=
cam
> pusid,campus_name,student_address2,student_sex,student_mi,student_work_ph=
one
> ,student_ssn,datelstmod,syschoolstatusid,systudentid,dlstate,dlnumber,ali=
enn
> um,balover10k,balover5k)
> 2009-07-16 16:53:20 ERROR: =C2=A0out of shared memory
>

i can't make an example with this... where's the value clause... what
were you inserting?

> There is only one table.
>

great! can you share (if you prefer in private, yes i'm the same that
makes the above comment ;) the structure of that single table and if
you can the inserts that are executing... what i'm looking for is what
is triggering that error and if it's something we can repeat in other
environments (say something less evil like linux)

--
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157



--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157