"Juan C. Aragon" writes:
> 2009-07-16 16:54:05 EDTWARNING: out of shared memory
> 2009-07-16 16:54:05 EDTFATAL: out of shared memory
You might be running out of lock-table space ... does raising
max_locks_per_transaction help? (Note you need a postmaster restart
to change that.)
cc: the -list this time
-- Forwarded message --
From: Jaime Casanova
Date: Thu, Jul 16, 2009 at 5:18 PM
Subject: Re: [BUGS] WARNING: out of shared memory
To: "Juan C. Aragon"
it's better for you to always write to the list because there are more
people that c
On Thu, Jul 16, 2009 at 4:41 PM, Juan C. Aragon 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 finis
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 messa