Handling large number transactions

From: Mahesh Govind <mahesh(at)digiledge(dot)in>
To: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Handling large number transactions
Date: 2023-08-09 16:40:30
Message-ID: MAXPR01MB2286D2627D54B2D4EB5760E8A512A@MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear Experts ,

I have the following scenario.

On a given day I have to insert 3-4 million rows of data to a table .For performance reasons I would like to purge this data and move to another history db.
The OLTP part I would like to do from one DB and the GUI queries I would like to do from a different DB replica .
Could you please help me with some pointers for the same .

with thanks and regards
mahesh

Browse pgsql-novice by date

  From Date Subject
Next Message Ron Watkins 2023-08-14 15:19:20 create read-only and revoke create function?
Previous Message Laurenz Albe 2023-07-28 06:24:37 Re: Run make checkinstall with configurable user.