pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Arthur Zakirov <a.zakirov@postgrespro.ru>
To: Michael Paquier <michael@paquier.xyz>
To: Grigory Smolkin <g.smolkin@postgrespro.ru>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: [PATCH] xlogreader: do not read a file block twice
Date: Tue, 12 Feb 2019 11:44:14 +0300
Message-ID: <1fa0c9fe-32a5-3ebd-e9c2-b5e2c9abc03e@postgrespro.ru> (raw)
In-Reply-To: <20190212042300.GL1475@paquier.xyz>
References: <2ddf4a32-517e-d6f4-d992-4a63b6035bfd@postgrespro.ru>
	<87e30af6-f85a-dc95-4574-95cded028786@postgrespro.ru>
	<20190212042300.GL1475@paquier.xyz>

On 12.02.2019 07:23, Michael Paquier wrote:
>> On 02/11/2019 07:25 PM, Arthur Zakirov wrote:
>>> Grigory noticed that one of our utilities has very slow performance when
>>> xlogreader reads zlib archives. We found out that xlogreader sometimes
>>> reads a WAL file block twice.
>>>
>>> What do you think?
> 
> I think that such things, even if they look simple, need a careful
> lookup, and I have not looked at the proposal yet.  Could you add it
> to the next commit fest so as we don't lose track of it?
> https://commitfest.postgresql.org/22/

Of course. Agree, it may be a non trivial case. Added as a bug fix:
https://commitfest.postgresql.org/22/1994/

-- 
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company




view thread (11+ messages)  latest in thread

Message-ID: <1fa0c9fe-32a5-3ebd-e9c2-b5e2c9abc03e@postgrespro.ru>
Permalink:  ../1fa0c9fe-32a5-3ebd-e9c2-b5e2c9abc03e@postgrespro.ru/
Also on:    postgresql.org/message-id/1fa0c9fe-32a5-3ebd-e9c2-b5e2c9abc03e@postgrespro.ru

 · 

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-hackers@postgresql.org
  Cc: a.zakirov@postgrespro.ru, michael@paquier.xyz, g.smolkin@postgrespro.ru, pgsql-hackers@lists.postgresql.org
  Subject: Re: [PATCH] xlogreader: do not read a file block twice
  In-Reply-To: <1fa0c9fe-32a5-3ebd-e9c2-b5e2c9abc03e@postgrespro.ru>

* 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