Re: parallel pg_restore blocks on heavy random read I/O on all children processes

2025-04-09 Thread Hannu Krosing
You may be interested in a patch "Adding pg_dump flag for parallel export to pipes"[1] which allows using pipes in directory former parallel dump and restore. There the offsets are implicitly taken care of by the file system. [1] https://www.postgresql.org/message-id/CAH5HC97p4kkpikar%2BswuC0Lx4Y

Question on what Duration in the log

2025-04-09 Thread Vitale, Anthony, Sony Music
Hello All In my PG Version 14 log I have set to log the duration of sql (Example of one log row below). 2025-04-08 07:31:57 UTC:XXX(55994):XXX:[8949]:LOG: duration: 6555.756 ms execute S_381: {Actual Parameterized Sql executed} This Shows the Execution of a JDBC Server Side Prepared stateme

RE: Question on what Duration in the log

2025-04-09 Thread Vitale, Anthony, Sony Music
Thanks Tom Perfect. Anthony Vitale   This message is only for the use of the persons(s) to whom it is intended. It may contain privileged and confidential information within the meaning of applicable law. If you are not the intended recipient, please do not use this information for any purpose

Re: Question on what Duration in the log

2025-04-09 Thread Tom Lane
"Vitale, Anthony, Sony Music" writes: > In my PG Version 14 log I have set to log the duration of sql (Example of one > log row below). > 2025-04-08 07:31:57 UTC:XXX(55994):XXX:[8949]:LOG: duration: 6555.756 ms > execute S_381: {Actual Parameterized Sql executed} > This Shows the Execution of