On Thu, Jul 16, 2009 at 4:41 PM, Juan C. Aragon<j...@keisercomputers.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
