Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1u7m-0002AP-67 for pgsql-admin@arkaria.postgresql.org; Mon, 17 Sep 2018 14:03:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1u7k-0003G1-B2 for pgsql-admin@arkaria.postgresql.org; Mon, 17 Sep 2018 14:03:36 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1u7k-0003Fu-0Z for pgsql-admin@lists.postgresql.org; Mon, 17 Sep 2018 14:03:36 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1u7d-0004XI-VU for pgsql-admin@lists.postgresql.org; Mon, 17 Sep 2018 14:03:34 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 98B695F79C; Mon, 17 Sep 2018 10:03:29 -0400 (EDT) Date: Mon, 17 Sep 2018 10:03:29 -0400 From: Stephen Frost To: Scott Ribe Cc: pgsql-admin@lists.postgresql.org Subject: Re: Big image tables maintenance Message-ID: <20180917140329.GW4184@tamriel.snowman.net> References: <0F8CB802-9FBC-4EA3-98AE-E81F26B3E559@elevated-dev.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="IF36ViUsfxDRDLKY" Content-Disposition: inline In-Reply-To: <0F8CB802-9FBC-4EA3-98AE-E81F26B3E559@elevated-dev.com> User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --IF36ViUsfxDRDLKY Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Scott Ribe (scott_ribe@elevated-dev.com) wrote: > On 09/17/2018 07:38 AM, still Learner wrote: > > 3. Taking the backup of 20TB data, is big task. Any more feasible solut= ion other than online backup/pg_dump? >=20 > That's an argument for keeping the presumably immutable files on the file= system. (There are arguments against as well.) While I'm not generally against the idea of keeping files on the filesystem, I'm not sure how that really changes things when it comes to backup..? If anything, having the files on the filesystem makes backing things up much more awkward, since you don't have the transactional guarantees on the filesystem that you do in the database and if you push the files out but keep the metadata and indexes in the database then you have to deal with reconsiling the two, in general and particularly when performing a backup/restore. Thanks! Stephen --IF36ViUsfxDRDLKY Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJbn7QxAAoJEO1sijiDR2RVyUgQAKCU9f5rYT/eDA+mbv7kdpOr TO9Xrrl+3R8BIkeeGFiZ4C7vpgX1kK1dfr8UIQ2ruzbadQGvCQuCYbuLtINTqFQd I1fVUCd/muX+Zn0YmAd0wf0gkOJH6ufDApwNpkJ9FjKjKQ16gv0eSJk0HU/3AIaj ZyBGI34VWUvMOxXvAEytRipRxORrmqOJaa0d96a4UgIBDLexSVoqC7lBibtFGgkF CiZoZCWUJlZK1413fskYz/+eVRrqtURamoQNkUVR7aSTqsZOCb3jCboOdXtrJHYp pYXxrmia+JATX7vwcgZNdl5vskB20rJERouL83g+4izTjDxw0dIUIrkMQgS3QSBF Zxjo23rMbrBvHtC+7PJYvI1DKbCWlDNwP4puVkox2w+Q91KxZUVadIIS9lKR+cfV ZGDNR7zsV1FBQ8+7GwmJJeb4a/Hm2JBtw+C0e3qZj3bniNPXEg9TbM+reik48MvU xq0rIksLFjLyf5yL3770cZXk6nMFN1Fk0qm2pFO+KSBURomHy5GGiJclSiYJboca mtxp45AkCwxK3Sl/LuD9mawQAzD69mz+ba3uVdz35OUFOk6t6GOoPLbNmtYO8oMq ShVgCu2Rm5Ry8K4w05EQRUWRhklY6RShV9VWLuoU1It/wFFO9u87vrJZUOhR+Tja S9UY/G3s7XpKkkO7v2rK =w4d0 -----END PGP SIGNATURE----- --IF36ViUsfxDRDLKY--