pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andres Freund <andres@2ndquadrant.com>
To: Jeff Frost <jeff@pgexperts.com>
Cc: Matheus de Oliveira <matioli.matheus@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Soni M <diptatapa@gmail.com>
Cc: Heikki Linnakangas <hlinnakangas@vmware.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Postgres Replaying WAL slowly
Date: Mon, 30 Jun 2014 22:15:23 +0200
Message-ID: <20140630201523.GV26930@awork2.anarazel.de> (raw)
In-Reply-To: <B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com>
References: <20140630171416.GK21422@awork2.anarazel.de>
	<CAAMgDXnT8cQbwxcNXfFKONrRVAKoGhR-3FWYSX_5gJcFrEMPMQ@mail.gmail.com>
	<8DA8C140-818D-4184-AAE6-CA37278B983C@pgexperts.com>
	<20140630183908.GT26930@awork2.anarazel.de>
	<0A7B96D4-DB10-49A8-A268-F28960F2E137@pgexperts.com>
	<F3E1168D-8D49-407E-A8B7-B3ED81C93DCB@pgexperts.com>
	<20300.1404156750@sss.pgh.pa.us>
	<C64129CF-D034-4311-AD32-09EF048C3E93@pgexperts.com>
	<CAJghg4Lq2rg7mMzRfEartAQK1c83veoW3TWroQsSvXMqBQ9h+w@mail.gmail.com>
	<B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On 2014-06-30 12:57:56 -0700, Jeff Frost wrote:
> 
> On Jun 30, 2014, at 12:54 PM, Matheus de Oliveira <matioli.matheus@gmail.com> wrote:
> 
> > 
> > On Mon, Jun 30, 2014 at 4:42 PM, Jeff Frost <jeff@pgexperts.com> 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



view thread (33+ messages)  latest in thread

Message-ID: <20140630201523.GV26930@awork2.anarazel.de>
Permalink:  ../20140630201523.GV26930@awork2.anarazel.de/
Also on:    postgresql.org/message-id/20140630201523.GV26930@awork2.anarazel.de

 · 

reply
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: andres@2ndquadrant.com, jeff@pgexperts.com, matioli.matheus@gmail.com, tgl@sss.pgh.pa.us, diptatapa@gmail.com, hlinnakangas@vmware.com
  Subject: Re: Postgres Replaying WAL slowly
  In-Reply-To: <20140630201523.GV26930@awork2.anarazel.de>

* 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