Re: pgsql: Allow configurable LZ4 TOAST compression.

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: pgsql: Allow configurable LZ4 TOAST compression.
Дата
Msg-id 539b8ea2-1f94-41f3-fb76-5b291662c174@dunslane.net
обсуждение исходный текст
Ответ на pgsql: Allow configurable LZ4 TOAST compression.  (Robert Haas <rhaas@postgresql.org>)
Список pgsql-committers
On 3/19/21 3:37 PM, Robert Haas wrote:
> Allow configurable LZ4 TOAST compression.
>


Looks like this has run into the heuristic in the buildfarm's cross
version upgrade module. This allows for up to 2000 lines of diff between
the dumps of the original and upgraded database. This has blown out by a
large number of diffs like this:


 CREATE TABLE "MySchema"."Foo" (
     f1 integer NOT NULL,
-    f2 text NOT NULL,
-    f3 text[]
+    f2 text COMPRESSION pglz NOT NULL,
+    f3 text[] COMPRESSION pglz
 );


Both dumps are made with the new version, so I'm not quite sure how I
should fix it. Maybe if it's an older version I should use the
--no-toast-compression argument, but it doesn't look like it's been
added to pg_dumpall unless I'm missing something.


cheers


andrew


-- 

Andrew Dunstan
EDB: https://www.enterprisedb.com




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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Provide recovery_init_sync_method=syncfs.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Avoid leaking memory in RestoreGUCState(), and improve comments.