Re: ALTER TABLE uses a bistate but not for toast tables

From: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: "Drouvot, Bertrand" <bdrouvot(at)amazon(dot)com>, pgsql-hackers(at)postgresql(dot)org, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: ALTER TABLE uses a bistate but not for toast tables
Date: 2024-11-19 14:45:19
Message-ID: pizwatztwg6a74gsfhtwwybsgu2guwvskb4jm44i4uoe3x5pae@64q3fxbkstnq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Mon, Jul 15, 2024 at 03:43:24PM GMT, Justin Pryzby wrote:
> @cfbot: rebased

Hey Justin,

Thanks for rebasing. To help with review, could you also describe
current status of the patch? I have to admit, currently the commit
message doesn't tell much, and looks more like notes for the future you.
The patch numbering is somewhat confusing as well, should it be v5 now?
From what I understand, the new patch does address the review feedback,
but you want to do more, something with copy to / copy from?

Since it's in the performance category, I'm also curious how much
overhead does this shave off? I mean, I get it that bulk insert strategy
helps with buffers usage, as you've implied in the thread -- but how
does it look like in benchmark numbers?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message wenhui qiu 2024-11-19 16:02:30 Re: A way to build PSQL 17.1 source on AIX platform
Previous Message Greg Sabino Mullane 2024-11-19 14:39:21 Re: Sample rate added to pg_stat_statements