Re: WARNING: out of shared memory

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