From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces? |
Date: | 2014-02-15 18:41:24 |
Message-ID: | 52FFB4D4.4020003@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2/15/2014 10:31 AM, Antman, Jason (CMG-Atlanta) wrote:
> If you had a single ~1TB database, and needed to be able to give fresh
> data copies to dev/test environments (which are usually largely idle)
> either on demand or daily, how would you do it? The only other thing
> that comes to mind is separate postgres instances (running multiple
> postgres instances per server?), one per database, for every
> environment. Which means that if 80% of the environments are idle at a
> given time, I'm effectively wasting 80% of the memory that I have
> allocated to shared buffers, etc. and I actually need 4x the resources
> I'm using? Unless postgres supports balooning of memory?
perhaps you could start/stop the test instances on demand as needed ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
From | Date | Subject | |
---|---|---|---|
Next Message | Antman, Jason (CMG-Atlanta) | 2014-02-15 18:49:32 | Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces? |
Previous Message | Karsten Hilbert | 2014-02-15 18:40:57 | Re: Restore postgresql data directory to tablespace on new host? Or swap tablespaces? |