Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lCc9W-0001GY-0R
	for pgsql-admin@arkaria.postgresql.org; Thu, 18 Feb 2021 05:47:02 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1lCc9U-0004BF-EA
	for pgsql-admin@arkaria.postgresql.org; Thu, 18 Feb 2021 05:47:00 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sasha@isando.evaristesys.co.za>)
	id 1lCc9U-00047q-4i
	for pgsql-admin@lists.postgresql.org; Thu, 18 Feb 2021 05:47:00 +0000
Received: from evariste01.clarocloud.co.za ([196.13.181.165]
 helo=isando.evaristesys.co.za)
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sasha@isando.evaristesys.co.za>)
	id 1lCc9R-0004Eh-Oi
	for pgsql-admin@postgresql.org; Thu, 18 Feb 2021 05:46:59 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed;
	d=evaristesys.com; s=defaultdkim; h=Sender:To:In-Reply-To:References:
	Message-Id:Date:Subject:Mime-Version:From:Content-Transfer-Encoding:
	Content-Type:Reply-To:Cc:Content-ID:Content-Description:Resent-Date:
	Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:
	List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive;
	 bh=9XFKFdl4ocx84YL4CCM4tE+vrb0GwqasAmPMBCb509M=; b=sDjZvcQch9tHCtFX5mp199ROH
	g10TcIw7jFsyaKo7JhH2Cs/pXQMumBSWWYOv14PIItHd3mj+fBYBPWTueT7ZbSvabKmXXKmtI2T2r
	JiMtTpmbGU9yL+kHO8jspfKVxfaG3gWypc8ckfhZ0AX812XUfsE/AXN7eWW9uO4dHoSbc=;
Received: from c-73-108-145-86.hsd1.ga.comcast.net ([73.108.145.86]
 helo=[172.30.105.150])
	by isando.evaristesys.co.za with esmtpsa
 (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <sasha@isando.evaristesys.co.za>)
	id 1lCc9N-0000hL-0p
	for pgsql-admin@postgresql.org; Thu, 18 Feb 2021 07:46:53 +0200
Content-Type: multipart/alternative;
 boundary=Apple-Mail-1D59B465-6DBA-4DE6-BBFD-DF2394D7C1AB
Content-Transfer-Encoding: 7bit
From: Alex Balashov <abalashov@evaristesys.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Scaling a fast growing database
Date: Thu, 18 Feb 2021 00:46:48 -0500
Message-Id: <2A0D374F-2DF6-4D22-A365-6FDE81057872@evaristesys.com>
References: 
 <CALhHtcCAvju=LkBAFh380wCuQWJjjXWbh66ScNAUqaAwe5nfpg@mail.gmail.com>
In-Reply-To: 
 <CALhHtcCAvju=LkBAFh380wCuQWJjjXWbh66ScNAUqaAwe5nfpg@mail.gmail.com>
To: pgsql-admin@postgresql.org
X-Mailer: iPhone Mail (18D52)
Sender: sasha@isando.evaristesys.co.za
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk


--Apple-Mail-1D59B465-6DBA-4DE6-BBFD-DF2394D7C1AB
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Partitioning!

https://www.postgresql.org/docs/current/ddl-partitioning.html

=E2=80=94
Sent from mobile, with due apologies for brevity and errors.

> On Feb 18, 2021, at 12:42 AM, Yambu <hyambu@gmail.com> wrote:
>=20
> =EF=BB=BF
> Hello
>=20
> One of my tables is getting 1mil records per week , what changes do i need=
 to make, to keep it fast and scalable?
>=20
> regards

--Apple-Mail-1D59B465-6DBA-4DE6-BBFD-DF2394D7C1AB
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Partitioning!<div><br></div><div><a href=3D=
"https://www.postgresql.org/docs/current/ddl-partitioning.html">https://www.=
postgresql.org/docs/current/ddl-partitioning.html</a><br><br><div dir=3D"ltr=
">=E2=80=94<div>Sent from mobile, with due apologies for brevity and errors.=
</div></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Feb 18, 2021, a=
t 12:42 AM, Yambu &lt;hyambu@gmail.com&gt; wrote:<br><br></blockquote></div>=
<blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<div dir=3D"ltr">Hello<b=
r><div><br></div><div>One of my tables is getting 1mil records per week , wh=
at changes do i need to make, to keep it fast and scalable?</div><div><br></=
div><div>regards</div></div>
</div></blockquote></div></body></html>=

--Apple-Mail-1D59B465-6DBA-4DE6-BBFD-DF2394D7C1AB--