Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eCx43-0007kH-0F for pgsql-admin@arkaria.postgresql.org; Fri, 10 Nov 2017 00:20:55 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eCx42-0002dK-J3 for pgsql-admin@arkaria.postgresql.org; Fri, 10 Nov 2017 00:20:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eCx2D-0005fH-19 for pgsql-admin@postgresql.org; Fri, 10 Nov 2017 00:19:01 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1eCx2A-0006OV-Qu for pgsql-admin@postgresql.org; Fri, 10 Nov 2017 00:19:00 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id CABE55F795; Thu, 9 Nov 2017 19:18:57 -0500 (EST) Date: Thu, 9 Nov 2017 19:18:57 -0500 From: Stephen Frost To: rammohan ganapavarapu Cc: pgsql-admin@postgresql.org Subject: Re: Partitions Message-ID: <20171110001857.GV4628@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="IltC7LFAEAeusRP3" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.21 (2010-09-15) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --IltC7LFAEAeusRP3 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * rammohan ganapavarapu (rammohanganap@gmail.com) wrote: > I have a requirement to create monthly partitions in my db, i am trying to > understand what is the best way to do it, i know i can run a cron job to > check if partition exist and create if not at the starting of month. Any > suggestions? I'd suggest you take a look at pg_partman. Thanks! Stephen --IltC7LFAEAeusRP3 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJaBPBxAAoJEO1sijiDR2RVJS4QALlCqFKwV1JrI0nEoMEP8mwr i4e6pvzVKQXzIz8MgD5H04ln2/6tCumsQw28JyGQLNTWGtFIa4XXZt51C8f7HwrG CHt8CsFg0NIr/0cCVn8v7GdqlxsdZhFeh5YHHeQD+rjNWs2tkDCSyz1uq5B3DWiD jMm6I0Z+DVLjFa63WMcWddAm1Fm0VteITjMusm5FNaoixfYJXd+kbKTw2Y+IUVyR ORl44Nz3gw5nIAgSBXm06gQT+lfSMBQBl9xiJ9LfMedUBM6PEUUDbNevfCXJaZ8l SM244eQT2mkwAou5qd/LZNxvJ0X4+SbSm7PwdM/gCreDwkOvsQ7QOn72T9Y6GsMi +Qr5qfPpnbXpDvWy7NOsOqXdHc6JdM5MBkJz60OusaREYkObs0iqSRuMR3yHuOsF p49n0Lu6Xdgcgdvda5QZPSvRyS6Dx5qRV7zH0C5obqkIWseLfng2xb1AWN1y/aGe ojDx0OsPIDSg3HVFPxvMWg3eyCplEwl8NUpygDhKmnnKEZcafSkPrMuM5lU+lAmk UBzZE1e8FdJ5iEHUMWrBwzVS7h1ir4CphFKUVM0+MjBEPPIG4lZryeQhxbsu8wlY V3dr4My+hmAuq9hXjxdEYXkk3KSlGuydAlqwftLby5uaBF36QavaST91TA7RPEH/ bg9uGnAU2Y4Z47nN3bly =8E41 -----END PGP SIGNATURE----- --IltC7LFAEAeusRP3--