Re: Archiving solutions

Dear imeran ,

Thanks for your support.

Dears,

Appreciate your support in simple solution to implement it.

Thanks

في الأحد، ١٢ يناير ٢٠٢٥ ١١:٢٣ م Imran Khan <imran(dot)k(dot)23(at)gmail(dot)com> كتب:

> 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(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> What is the regular housekeeping.
>>
>> Thanks
>>
>> في الأحد، ١٢ يناير ٢٠٢٥ ١٠:٥٥ م Imran Khan <imran(dot)k(dot)23(at)gmail(dot)com> كتب:
>>
>>> 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(at)gmail(dot)com> wrote:
>>>
>>>> Dears ,
>>>>
>>>> Appreciate your support I have 2.4 TB database and I need to implement
>>>> archiving solutions to prevent data growthing.
>>>>
>>>> Thanks
>>>>
>>>