Postgres Pro
Downloads
Home   >   mailing lists

Re: Methods to quickly spin up copies of an existing databases - Mailing list pgsql-general

From Kenneth Marshall
Subject Re: Methods to quickly spin up copies of an existing databases
Date
Msg-id 20190301200017.GM15586@aart.rice.edu
Whole thread Raw
In response to Re: Methods to quickly spin up copies of an existing databases  (Kevin Wilkinson <w.kevin.wilkinson@gmail.com>)
Responses Re: Methods to quickly spin up copies of an existing databases  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-general
Tree view 
On Fri, Mar 01, 2019 at 11:57:30AM -0800, Kevin Wilkinson wrote:
> if you are able/willing to use ZFS (rather than ext4, xfs, ...) to
> store your database, then it might work for you. ZFS is
> copy-on-write so it can very quickly clone a database.
> 
> kevin

Hi Arjun

Redhat 7 does have LVM snapshots that does something similar. Kevin is
correct, COW is the secret.

Regards,
Ken

pgsql-general by date:

Previous
From: Kevin Wilkinson
Date:
Subject: Re: Methods to quickly spin up copies of an existing databases
Next
From: Arjun Ranade
Date:
Subject: Methods to quickly spin up copies of an existing databases