Re: Different compression methods for FPI

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Different compression methods for FPI
Дата
Msg-id 20210622031358.GF29179@telsasoft.com
обсуждение исходный текст
Ответ на Re: Different compression methods for FPI  (Dilip Kumar <dilipbalaut@gmail.com>)
Ответы Re: Different compression methods for FPI  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Tue, May 25, 2021 at 12:05:19PM +0530, Dilip Kumar wrote:
> +++ b/src/test/recovery/t/011_crash_recovery.pl
> @@ -14,7 +14,7 @@ use Config;
>  plan tests => 3;
> 
>  my $node = get_new_node('primary');
> -$node->init(allows_streaming => 1);
> +$node->init();
>  $node->start;
> 
> How this change is relevant?

It's necessary for the tests to pass - see the prior discussions.
Revert them and the tests fail.

time make -C src/test/recovery check
#   Failed test 'new xid after restart is greater'

@Michael: I assume that if you merge this patch, you'd set your animals to use
wal_compression=lz4, and then they would fail the recovery tests.  So the
patches that you say are unrelated still seem to me to be a prerequisite.

From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
                                                                                                          
 
Subject: [PATCH v8 2/9] Run 011_crash_recovery.pl with wal_level=minimal
                                                                                                          
 

From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
                                                                                                          
 
Subject: [PATCH v8 3/9] Make sure published XIDs are persistent
                                                                                                          
 

+/* compression methods supported */
+#define BKPIMAGE_COMPRESS_PGLZ 0x04
+#define BKPIMAGE_COMPRESS_ZLIB 0x08
+#define BKPIMAGE_COMPRESS_LZ4  0x10
+#define BKPIMAGE_COMPRESS_ZSTD 0x20
+#define        BKPIMAGE_IS_COMPRESSED(info) \
+       ((info & (BKPIMAGE_COMPRESS_PGLZ | BKPIMAGE_COMPRESS_ZLIB | \
+                         BKPIMAGE_COMPRESS_LZ4 | BKPIMAGE_COMPRESS_ZSTD)) != 0)

You encouraged saving bits here, so I'm surprised to see that your patches
use one bit per compression method: 2 bits to support no/pglz/lz4, 3 to add
zstd, and the previous patch used 4 bits to also support zlib.

There are spare bits available for that, but now there can be an inconsistency
if two bits are set.  Also, 2 bits could support 4 methods (including "no").

-- 
Justin



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Paul Guo
Дата:
Сообщение: Re: Two patches to speed up pg_rewind.
Следующее
От: "osumi.takamichi@fujitsu.com"
Дата:
Сообщение: RE: Fix for segfault in logical replication on master