Fwd: WARNING: out of shared memory

cc: the -list this time

---------- Forwarded message ----------
From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Date: Thu, Jul 16, 2009 at 5:18 PM
Subject: Re: [BUGS] WARNING: out of shared memory
To: "Juan C. Aragon" <juan(at)keisercomputers(dot)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(at)keisercomputers(dot)com> wrote:
> Yes, this is another server.
>
> There is 8GB of memory.
>
> max_connections = 100
>
> shared_buffers = 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:  out of shared memory
> 2009-07-16 16:53:20 STATEMENT:  INSERT 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,sycam
> pusid,campus_name,student_address2,student_sex,student_mi,student_work_phone
> ,student_ssn,datelstmod,syschoolstatusid,systudentid,dlstate,dlnumber,alienn
> um,balover10k,balover5k)
> 2009-07-16 16:53:20 ERROR:  out 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ón de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157