Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cW4AV-00033K-2O for pgsql-performance@arkaria.postgresql.org; Tue, 24 Jan 2017 16:42:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cW4AU-0001AA-Li for pgsql-performance@arkaria.postgresql.org; Tue, 24 Jan 2017 16:42:02 +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 1cW48p-0007jV-G5 for pgsql-performance@postgresql.org; Tue, 24 Jan 2017 16:40:19 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cW48l-0004zY-UK for pgsql-performance@postgresql.org; Tue, 24 Jan 2017 16:40:18 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 41B6A5F796; Tue, 24 Jan 2017 11:39:15 -0500 (EST) Date: Tue, 24 Jan 2017 11:39:15 -0500 From: Stephen Frost To: Rick Otten Cc: "pgsql-performance@postgresql.org" Subject: Re: Backup taking long time !!! Message-ID: <20170124163915.GX18360@tamriel.snowman.net> References: <0fb0c8c3f69340a3a7d70b1c39fa2b2c@cyient.com> <20170122145740.GE18360@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="AJXs2gEBFUYXNg1q" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 11:35:49 up 199 days, 18:00, 5 users, load average: 0.06, 0.13, 0.15 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -5.1 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --AJXs2gEBFUYXNg1q Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * Rick Otten (rottenwindfish@gmail.com) wrote: > Actually, I think this may be the way Oracle Hot Backups work. It was my > impression that feature temporarily suspends writes into a specific > tablespace so you can take a snapshot of it. It has been a few years since > I've had to do Oracle work though and I could be mis-remembering. People > may be confusing Oracle and PostgreSQL. Yes, that thought has occured to me as well, in some other database systems you can ask for the system to be quiesced. Thanks! Stephen --AJXs2gEBFUYXNg1q Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYh4MyAAoJEO1sijiDR2RVQC8P/2x2E497IUzgJTiPjpwXnuci uwwFlzD8ef3pC5zgHyfTlxy2OLofXL0zW+G1R0NkToqFLnXsrXDu41N/Wl+f8NiR VSI1B4IYbcfC3M9nfFZ4850HW334W4PGppd8JCn/0g6vFPI22N8b8+e5ma3ZtmlN C47PoYZf6ipx0IY+S8FA4P+6ddbla6rS5sw1LA/dbuLjZoRf038Osd0qNuffU6ci 14AlgNwEzhcU1E6DOirIlhwhSZBzrnOITWse8WJq9vJDkBcyetloV3X2pc7C2x+b viH8tyPsqdkOLvWmByANcTsiplj97ti/oQ6IzSka36r32uu5/q9ltqUrJmpLn72I JPwnUSH6P/vqkj9Rr7uW6MXwo0tcNqZH/iZbKINsaqiJ3Ljig+mxwDGgLOak/sKH CrUxukcJBjh73dhujCXmI2RD76BZ7Np6ScVTfskWmgu5F2Zu+v8Z/Rggrq39sDQz leOxm1Jg+i0zCwoVsIWXAd7xyKZrT1EVPVGYbWWJcWImQlHgUSv+rUHFKP6k2PJm rzWXLLv+r92eFzeaEdTvOBW8GwH3FijvLsCRvOYYzXk4/cyhpE22IZvzjy73JQ+c dJsnYpb1shNI9qj6DZMZpdrqr6J0alT3uFoHGt6BKyzTXMs6uAPWgid+J9g6qyKV R7Ow5M1djxpUEuBO2ENT =BOMK -----END PGP SIGNATURE----- --AJXs2gEBFUYXNg1q--