Hi ~~Na-iem Dollie, Thanks for your reply, In SQL Server there is an option to take Full backup and Differential Backup for a particular database. Like that, we need to take the differential Backup in PostgreSQL. This is my primary need. Thanks, Karthick Ramu From: Daevor The Devoted [mailto:dollien@xxxxxxxxx] Hi Karthick I'm a little rusty on PG (it's been about a decade since I last worked intensely with it), but I seem to remember that restoring with indexes can be very slow. The faster approach is to restore without indexes, and then create the indexes once the data restore is complete. My knowledge may be outdated, so best to check with others that have more recent knowledge. However, it's probably worth investigating in the meantime. Okay, I just had a quick look at the documentation, and it seems there is an option to run multiple concurrent jobs for the time-consuming parts of a restore (which includes index creation): -j see: https://www.postgresql.org/docs/current/app-pgrestore.html (or check the docs for whatever PG version you have) Good luck! ~~Na-iem Dollie On Mon, Feb 21, 2022 at 6:59 AM Techsupport <techsupport@xxxxxxxxxxx> wrote:
|
