cc: the -list this time
---------- Forwarded message ---------- From: Jaime Casanova <jcasa...@systemguards.com.ec> Date: Thu, Jul 16, 2009 at 5:18 PM Subject: Re: [BUGS] WARNING: out of shared memory To: "Juan C. Aragon" <j...@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<j...@keisercomputers.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
