Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 439D463478A for ; Tue, 9 Mar 2010 08:35:24 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 86565-02-3 for ; Tue, 9 Mar 2010 12:35:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 15580635CD2 for ; Tue, 9 Mar 2010 08:34:22 -0400 (AST) Received: by gyh3 with SMTP id 3so1347193gyh.19 for ; Tue, 09 Mar 2010 04:34:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=Tsgp8GvrI3tO7fhB5pgbGDGfyAOBnGusI+fPJDG7zu8=; b=DGJqPYdCCmDIJ5jBLjmtLMs059CdMzAHSzSJESwDb4it10x4oJs8wyLIiiSJZM8qtl 4V53ZD3EzqByYJBDtAVPMwTmKlTaIpLABrrEhxPAFZte7eM6ox3a0RvbGZqIL7IUoPbw vFsI7IQgVZuarbVRoqNflEl/SHJOzl5uw+zYs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=dRYu5QrGEfDVzpFIlLAuvbXEySJHchdQYynwplKYtyjlKGh+39FYVZ6f1YYmjW03mm xcXb3P3Ft1IzmkuyQVHwWth43lMHbm5EuQD/yJ7Q3UvX+NFw9fYL5ERNd8UVT6paZjNf ky6OfY4p3ZVE7egHdd6vhkMili81X86Rd9Bts= MIME-Version: 1.0 Received: by 10.90.8.22 with SMTP id 22mr553864agh.66.1268138052043; Tue, 09 Mar 2010 04:34:12 -0800 (PST) In-Reply-To: <919b7db61003090138j6da56dffu5e0ddd4276168b48@mail.gmail.com> References: <919b7db61003090138j6da56dffu5e0ddd4276168b48@mail.gmail.com> Date: Tue, 9 Mar 2010 07:34:11 -0500 Message-ID: Subject: Re: Out of shared memory in postgres 8.4.2 and locks From: Merlin Moncure To: Vidhya Bondre Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.519 tagged_above=-10 required=5 tests=AWL=0.080, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/86 X-Sequence-Number: 37911 On Tue, Mar 9, 2010 at 4:38 AM, Vidhya Bondre wrote= : > Hi All, > > We have=A0installed postgres 8.4.2 on production. > > We have a parition table structure for one of the=A0table. > > when=A0i am drop the master table we get the following error. > > drop table=A0table_name cascade; > WARNING:=A0 out of shared memory > ERROR:=A0 out of shared memory > HINT:=A0 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