Re: WARNING: out of shared memory

On Thu, Jul 16, 2009 at 4:41 PM, Juan C. Aragon<juan@keisercomputers.com> w=
rote:
> 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 =E2=80=
=9CWARNING:
> out of shared memory=E2=80=9D
>
> 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=C2=A0=C2=A0=C2=A0 WARNING:=C2=A0 worker took too =
long to start;
> cancelled
>
> 2009-07-16 16:54:05 EDT=C2=A0=C2=A0=C2=A0 WARNING:=C2=A0 out of shared me=
mory
>
> 2009-07-16 16:54:05 EDT=C2=A0=C2=A0=C2=A0 FATAL:=C2=A0 out of shared memo=
ry
>
>

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 =E2=80=9Cout of shared memory=E2=80=9D
>

what's the value in max_connections?

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