Postgres Pro
Downloads
Home   >   mailing lists

Handling large number transactions - Mailing list pgsql-novice

From Mahesh Govind
Subject Handling large number transactions
Date
Msg-id MAXPR01MB2286D2627D54B2D4EB5760E8A512A@MAXPR01MB2286.INDPRD01.PROD.OUTLOOK.COM
Whole thread Raw
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Run make checkinstall with configurable user.
Next
From: Ron Watkins
Date:
Subject: create read-only and revoke create function?