Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Robert Klemme <shortcutter@googlemail.com>
Newsgroups: comp.databases.postgresql
Subject: Re: how do you make dev db small so easy on resources while keeping apps working?
Date: Thu, 06 Mar 2014 23:02:16 +0100
Lines: 18
Message-ID: <bns9j9Fgg31U1@mid.individual.net>
References: <38bc55c1-03b0-496b-9ad7-acac40f59cc6@googlegroups.com> <bhbuvaFa8e1U2@mid.individual.net> <67923826-d19a-4453-b080-4625fa479941@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net vDLIK4hN5BXq0w5h9XpeMwZQxTcs+ZIaNLkmPalYuAAhbXEuY=
Cancel-Lock: sha1:o1kjNNpgyPG2rOIE153aYEOXmgU=
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:24.0) Gecko/20100101 Thunderbird/24.3.0
In-Reply-To: <67923826-d19a-4453-b080-4625fa479941@googlegroups.com>
Xref: csiph.com comp.databases.postgresql:543

On 01/27/2014 06:49 AM, johannes falcone wrote:
> Hm
>
> Lets say a production db is 800G.
>
> Do people using postgresql have a QA and DEv db as big?
>
> Or is there a way to make the qa n dev smaller?
>
> I would think one way would be to cut from say 1 million users to 10.
> And do same for say transaction table.
> Leaving tables involving products intact.
>
> What do you do ?
>


Depends on the type of QA you want to do.