Re: 回复：Re: 回复：Re: speed up pg_upgrade with large number of tables
| От | Hari Krishna Sunder |
|---|---|
| Тема | Re: 回复：Re: 回复：Re: speed up pg_upgrade with large number of tables |
| Дата | |
| Msg-id | CAAeiqZ00_O=GTq6qrG7wfXOjrU4v3HMDuNX8mOP8AH6AWQBiaw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: 回复：Re: 回复：Re: speed up pg_upgrade with large number of tables (Nathan Bossart <nathandbossart@gmail.com>) |
| Ответы |
Re: 回复：Re: 回复：Re: speed up pg_upgrade with large number of tables
|
| Список | pgsql-hackers |
The restore side speedups suggested by Yang seem reasonable and can potentially speed up the process. We can even go a bit further by starting the new postgres in a --binary-upgrade mode and skip some of these locks completely.
On Sun, Jan 19, 2025 at 3:43 PM Nathan Bossart <nathandbossart@gmail.com> wrote:
On Mon, Jul 08, 2024 at 03:22:36PM +0800, 杨伯宇(长堂) wrote:
> Besides, https://commitfest.postgresql.org/48/4995/ seems insufficient to
> this situation. Some time-consuming functions like check_for_data_types_usage
> are not yet able to run in parallel. But these patches could be a great
> starting point for a more efficient parallelism implementation. Maybe we can
> do it later.
I actually just wrote up the first version of the patch for parallelizing
the data type checks over the weekend. I'll post it shortly.
--
nathan
В списке pgsql-hackers по дате отправления: