Re: In-placre persistance change of a relation

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: Jakub(dot)Wartak(at)tomtom(dot)com
Cc: tsunakawa(dot)takay(at)fujitsu(dot)com, osumi(dot)takamichi(at)fujitsu(dot)com, sfrost(at)snowman(dot)net, masao(dot)fujii(at)oss(dot)nttdata(dot)com, ashutosh(dot)bapat(dot)oss(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: In-placre persistance change of a relation
Date: 2021-12-23 06:01:41
Message-ID: 20211223.150141.567663666306444193.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At Wed, 22 Dec 2021 08:42:14 +0000, Jakub Wartak <Jakub(dot)Wartak(at)tomtom(dot)com> wrote in
> I think there's slight omission:
...
> apparently reindex_index() params cannot be NULL - the same happens with switching persistent

Hmm. a3dc926009 has changed the interface. (But the name is also
changed after that.)

-reindex_relation(Oid relid, int flags, int options)
+reindex_relation(Oid relid, int flags, ReindexParams *params)

> I'll also try to give another shot to the patch early next year - as we are starting long Christmas/holiday break here
> - with verifying WAL for GiST and more advanced setup (more crashes, and standby/archiving/barman to see
> how it's possible to use wal_level=minimal <-> replica transitions).

Thanks. I added TAP test to excecise the in-place persistence change.

have a nice holiday, Jakub!

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

Attachment Content-Type Size
v12-0001-In-place-table-persistence-change.patch text/x-patch 83.0 KB
v12-0002-New-command-ALTER-TABLE-ALL-IN-TABLESPACE-SET-LO.patch text/x-patch 11.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2021-12-23 06:33:35 Re: In-placre persistance change of a relation
Previous Message Masahiko Sawada 2021-12-23 05:26:03 Re: parallel vacuum comments