Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X1hzB-00041R-QP for pgsql-performance@arkaria.postgresql.org; Mon, 30 Jun 2014 20:15:33 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1X1hzB-0005NZ-Av for pgsql-performance@arkaria.postgresql.org; Mon, 30 Jun 2014 20:15:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1X1hzA-0005NT-H8 for pgsql-performance@postgresql.org; Mon, 30 Jun 2014 20:15:32 +0000 Received: from mail.anarazel.de ([217.115.131.40]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1X1hz7-0000Pu-7D for pgsql-performance@postgresql.org; Mon, 30 Jun 2014 20:15:31 +0000 Received: by mail.anarazel.de (Postfix, from userid 108) id 70222500001; Mon, 30 Jun 2014 22:15:28 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on mail X-Spam-Level: X-Spam-Status: No, score=-5.9 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.2.5 Received: from anarazel.de (p54AF441C.dip0.t-ipconnect.de [84.175.68.28]) (Authenticated sender: andres@anarazel.de) by mail.anarazel.de (Postfix) with ESMTPSA id 43CF14F0001; Mon, 30 Jun 2014 22:15:24 +0200 (CEST) Received: by anarazel.de (Postfix, from userid 1000) id ACA10100058; Mon, 30 Jun 2014 22:15:23 +0200 (CEST) Date: Mon, 30 Jun 2014 22:15:23 +0200 From: Andres Freund To: Jeff Frost Cc: Matheus de Oliveira , Tom Lane , Soni M , Heikki Linnakangas , pgsql-performance Subject: Re: Postgres Replaying WAL slowly Message-ID: <20140630201523.GV26930@awork2.anarazel.de> References: <20140630171416.GK21422@awork2.anarazel.de> <8DA8C140-818D-4184-AAE6-CA37278B983C@pgexperts.com> <20140630183908.GT26930@awork2.anarazel.de> <0A7B96D4-DB10-49A8-A268-F28960F2E137@pgexperts.com> <20300.1404156750@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 2014-06-30 12:57:56 -0700, Jeff Frost wrote: > > On Jun 30, 2014, at 12:54 PM, Matheus de Oliveira wrote: > > > > > On Mon, Jun 30, 2014 at 4:42 PM, Jeff Frost wrote: > > And if you go fishing in pg_class for any of the oids, you don't find anything: > > > > That is probably because you are connected in the wrong database. Once you connect to the database of interest, you don't even need to query pg_class, just cast relation attribute to regclass: > > > > SELECT relation::regclass, ... > > FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()); > > > > Yah, i thought about that too, but verified I am in the correct DB. Just for clarity sake: So these are probably relations created in uncommitted transactions. Possibly ON COMMIT DROP temp tables? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance