Re: Archiving solutions

Thank you Imran

On Tue, 14 Jan 2025, 04:38 kasem adel, <kasemadel8(at)gmail(dot)com> wrote:

> 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
>>>>>
>>>>