Re: Archiving solutions

[kasem adel <kasemadel8@xxxxxxxxx>]

Dear imeran ,

Thanks for your support.

Dears,

Appreciate your support in simple solution to implement it.

Thanks

في الأحد، ١٢ يناير ٢٠٢٥ ١١:٢٣ م Imran Khan <imran.k.23@xxxxxxxxx> كتب:

Hi,

 How the data can be stored. Do you have historical data? If yes , then you can keep that data in archived tables or if that data is still required by business then store it in partitions monthly wise . You need to design the data storage with proper planning. Also, if you have dynamic and ever changing data and you have date records then store with respect to partitions and retain for last 3 or 6 months then move to archived tables or purge if not required .. keep track of indexes and capture long running SQL statements through pg_stat_statements extension and run explain plan to get the proper indexes created based on the output of that plan. Also, keep track of memory related parameters to check if any memory leak occurs resulting in EXCESSIVE swap space usage on OS. 

 That's my opinion but we have more experts here who can help us to understand more.

Thanks,

Imran 

On Sun, Jan 12, 2025, 11:57 PM kasem adel <kasemadel8@xxxxxxxxx> wrote:

Hi,

What is the regular housekeeping. 

Thanks 

في الأحد، ١٢ يناير ٢٠٢٥ ١٠:٥٥ م Imran Khan <imran.k.23@xxxxxxxxx> كتب:

Hi,

Plan to use table partitioning and do regular housekeeping of the cluster. 

Thanks,

Imran

On Sun, Jan 12, 2025, 11:42 PM kasem adel <kasemadel8@xxxxxxxxx> wrote:

Dears ,

Appreciate your support I have 2.4 TB database and I need to implement archiving solutions to prevent data growthing. 

Thanks