Re: Minimize checkpointer and walwriter io during pg_restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jun 6, 2024 at 8:54 AM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
On Thu, Jun 6, 2024 at 4:06 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
[snip] 
There are certainly negative effects of a large transaction, but I thought you want
to optimize the performance of a "pg_restore".  If you optimize one thing, you will
certainly pessimize some other things.  In the case at hand, you shouldn't run a
heavy data modifying workload in the same database concurrently to the large pg_restore.
 
pg_restore will be the only thing running.

The mere size of a transaction can be a problem as such in other databases like
Oracle, but not in PostgreSQL.

Understood.  I'll see if I can run another test before the "real" migration starts.

And... --single-transaction conflicts with --jobs.  Oh well.
 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux