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

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@2ndquadrant.com>
Cc: Jeff Frost <jeff@pgexperts.com>
Cc: Matheus de Oliveira <matioli.matheus@gmail.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: Wed, 02 Jul 2014 15:14:52 -0400
Message-ID: <19807.1404328492@sss.pgh.pa.us> (raw)
In-Reply-To: <20140702190111.GC25909@awork2.anarazel.de>
References: <B22B06CF-2BC0-4AB6-8E3C-FACDF8193F23@pgexperts.com>
	<20140630201523.GV26930@awork2.anarazel.de>
	<943ECC8E-8899-422E-937C-50DE20E1F7AC@pgexperts.com>
	<21474.1404160784@sss.pgh.pa.us>
	<2E438E7D-E3C1-47A1-A1AF-9FE50A14A302@pgexperts.com>
	<571D044B-260A-4E06-ACBC-8869B8F73C0F@pgexperts.com>
	<24455.1404169460@sss.pgh.pa.us>
	<BB7C727F-201D-4CA7-AB00-8EDF6EBFD04B@pgexperts.com>
	<608DF51D-AEFB-422B-AD2C-ABA9A114AA27@pgexperts.com>
	<18433.1404242437@sss.pgh.pa.us>
	<20140702190111.GC25909@awork2.anarazel.de>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-07-01 15:20:37 -0400, Tom Lane wrote:
>> It seems like there are three, not mutually exclusive, ways we might
>> address this:

> But I think more importantly it's probably quite possible to hit a
> similar problem without ON COMMIT DROP relations. Say DISCARD TEMP
> inside a transaction (with several subxacts) or so? So we probaly really
> should fix the bad scaling.

Well, my thought was that these approaches would address somewhat
different sets of use-cases, and we might well want to do more than one.
Even if StandbyReleaseLocks were zero-cost, not emitting the WAL in the
first place is surely considerably cheaper yet.

			regards, tom lane


-- 
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: <19807.1404328492@sss.pgh.pa.us>
Permalink:  ../19807.1404328492@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/19807.1404328492@sss.pgh.pa.us

 · 

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

* 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