From: Merlin Moncure <mmoncure@gmail.com>
To: Vidhya Bondre <meetvbondre@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Out of shared memory in postgres 8.4.2 and locks
Date: Tue, 9 Mar 2010 07:34:11 -0500
Message-ID: <b42b73151003090434yabba5me4489096769d4bc7@mail.gmail.com> (raw)
In-Reply-To: <919b7db61003090138j6da56dffu5e0ddd4276168b48@mail.gmail.com>
References: <919b7db61003090138j6da56dffu5e0ddd4276168b48@mail.gmail.com>
On Tue, Mar 9, 2010 at 4:38 AM, Vidhya Bondre <meetvbondre@gmail.com> wrote:
> Hi All,
>
> We have installed postgres 8.4.2 on production.
>
> We have a parition table structure for one of the table.
>
> when i am drop the master table we get the following error.
>
> drop table table_name cascade;
> WARNING: out of shared memory
> ERROR: out of shared memory
> HINT: You might need to increase max_locks_per_transaction.
>
> FYI : This sql was working fine on Postgres 8.3
>
> Can some one please let me know what is going wrong here.
are you using the same postgresql.conf? have you created more
partitions? using advisory locks?
In any event, increase the max_locks_per_transaction setting and
restart the database.
merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mmoncure@gmail.com, meetvbondre@gmail.com
Subject: Re: Out of shared memory in postgres 8.4.2 and locks
In-Reply-To: <b42b73151003090434yabba5me4489096769d4bc7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox