public inbox for [email protected]  

help / color / mirror / Atom feed

From: kasem adel <[email protected]>
To: Imran Khan <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: Archiving solutions
Date: Tue, 14 Jan 2025 01:08:10 +0200
Message-ID: <CAP-pBm8A-qWvLYXp2bReLHyAOz=x+2oi=zQ1NwuSCBgHvhiDfA@mail.gmail.com> (raw)
In-Reply-To: <CAC4eXDgpKf41W577BRnX=S8WsDm0PVWFSWy3SHrkMgyqQUUwCQ@mail.gmail.com>
References: <CAP-pBm8xZGJA_kpfxjK=S85N4QypRNYZqDy_G3Z+mAuRKgmdeA@mail.gmail.com>
	<CAC4eXDhjNpOTii+2czMw4JoXOtpGd27A1WCejRge+pky+pOMmw@mail.gmail.com>
	<CAP-pBm8ULevEiXCUigGacGCLg4njOK61LY9i_AfL66sPwwn-Bg@mail.gmail.com>
	<CAC4eXDgpKf41W577BRnX=S8WsDm0PVWFSWy3SHrkMgyqQUUwCQ@mail.gmail.com>

Dear imeran ,

Thanks for your support.

Dears,

Appreciate your support in simple solution to implement it.

Thanks



في الأحد، ١٢ يناير ٢٠٢٥ ١١:٢٣ م Imran Khan <[email protected]> كتب:

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Archiving solutions
  In-Reply-To: <CAP-pBm8A-qWvLYXp2bReLHyAOz=x+2oi=zQ1NwuSCBgHvhiDfA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox