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

help / color / mirror / Atom feed
From: Jeff Frost <jeff@pgexperts.com>
To: Matheus de Oliveira <matioli.matheus@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@2ndquadrant.com>
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 12:57:56 -0700
Message-ID: <B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com> (raw)
In-Reply-To: <CAJghg4Lq2rg7mMzRfEartAQK1c83veoW3TWroQsSvXMqBQ9h+w@mail.gmail.com>
References: <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
	<53AFCEE3.4080009@vmware.com>
	<CAAMgDXnKknBDk+Zb3BXau1cKV7y1A0vd9CJpX=vkSTXVGBrZwA@mail.gmail.com>
	<53B10C4C.8090701@vmware.com>
	<CAAMgDX=c8_6tutCDNiu38Z4wguKMGbhqznVNyMiOC5PZBpn1Fw@mail.gmail.com>
	<53B18CE0.4060501@vmware.com>
	<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>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>


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:

SELECT relation::regclass
    FROM pg_locks WHERE database = (SELECT oid FROM pg_database WHERE datname = current_database()) and mode = 'AccessExclusiveLock';

  relation
------------


 3245508214
 3245508273
 3245508272
 3245508257
 3245508469
 3245508274
 3245508373
 3245508468
 3245508210
 3245508463
 3245508205
 3245508260
 3245508265
 3245508434
(16 rows)=

view thread (33+ messages)  latest in thread

Message-ID: <B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com>
Permalink:  ../B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com/
Also on:    postgresql.org/message-id/B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com

 · 

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: jeff@pgexperts.com, matioli.matheus@gmail.com, tgl@sss.pgh.pa.us, andres@2ndquadrant.com, diptatapa@gmail.com, hlinnakangas@vmware.com
  Subject: Re: Postgres Replaying WAL slowly
  In-Reply-To: <B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.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