Hi Madhumitha,
On 08/08/2025 23:27, Madhumitha C wrote:
Could you please advise us on how we can optimize or reduce the restoration time?
I suggest asking this in the pgsql-performance mailing list. Have a look at this first before posting: https://wiki.postgresql.org/wiki/Guide_to_reporting_problems
Just off the cuff, you have to find the actual bottleneck first. In case you already have evidence to rule out everything else, you can have a look on this page for some options: https://www.postgresql.org/docs/current/populate.html.
Kind regards, Mircea Cadariu
