Horton

Re: Request for Guidance on Reducing PostgreSQL DB Restoration Time

Mircea Cadariu <cadariu.mircea@gmail.com>

View thread
From: Mircea Cadariu <cadariu.mircea@gmail.com>
To: Madhumitha C <madhumitha@titan.co.in>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Cc: Inieya Dharshini <Inieya@titan.co.in>, Paarkavi K Subramaniam <paarkavik@titan.co.in>
Date: 2025-08-11T00:10:21Z
Lists: pgsql-hackers 
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