Skip site navigation (1) Skip section navigation (2)

Re: WARNING: out of shared memory

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: "Juan C(dot) Aragon" <juan(at)keisercomputers(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: WARNING: out of shared memory
Date: 2009-07-16 21:49:17
Message-ID: 3073cc9b0907161449j44541c91g6ccd12e6afe99e5d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, Jul 16, 2009 at 4:41 PM, Juan C. Aragon<juan(at)keisercomputers(dot)com> wrote:
> We are working on Windows Server 2003 Enterprise with PostgreSQL 8.4, when
> we start populating a table with 130,000 records it start giving “WARNING:
> out of shared memory”
>
> on every record that was inserted. At the end it did not finish, it only
> inserted 4,000 records and got the following message:
>
>
>
> 2009-07-16 16:54:05 EDT    WARNING:  worker took too long to start;
> cancelled
>
> 2009-07-16 16:54:05 EDT    WARNING:  out of shared memory
>
> 2009-07-16 16:54:05 EDT    FATAL:  out of shared memory
>
>

but this, is a different thing...

how much memory you have in your machine? and how much has been
assigned to postgres via shared_buffers?

can you show a self contained example of this (eg: the minimun
structure of the table and the inserts you need to make the bug
happen)?

>
> Also, we are not able to login to the database with PgAdmin, getting same
> error “out of shared memory”
>

what's the value in max_connections?

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

In response to

Responses

pgsql-bugs by date

Next:From: Jaime CasanovaDate: 2009-07-16 22:35:40
Subject: Fwd: WARNING: out of shared memory
Previous:From: Jaime CasanovaDate: 2009-07-16 21:44:56
Subject: Re: FATAL: could not reattach to shared memory (key=268, addr=01E30000): 487

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group