Re: Methods to quickly spin up copies of an existing databases

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Kevin Wilkinson <w(dot)kevin(dot)wilkinson(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Methods to quickly spin up copies of an existing databases
Date: 2019-03-01 20:00:17
Message-ID: 20190301200017.GM15586@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arjun Ranade 2019-03-01 20:08:13 Methods to quickly spin up copies of an existing databases
Previous Message Kevin Wilkinson 2019-03-01 19:57:30 Re: Methods to quickly spin up copies of an existing databases