idle DB and resources

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: idle DB and resources
Date: 2009-02-16 10:26:13
Message-ID: 20090216112613.45cb5198@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We've one site already in production and another one that will take
its birth from the previous one.
Since editors have to prune and adapt content from the previous one
I'm going to duplicate the DB and put it online on the same box and
let editors do their job.

Later we may decide to move it on another box or leave it there
since once the editors job will be finished the DB will be much
smaller.

Meanwhile we will have 2 large DB, one of them being nearly idle.
Is the idle DB going to have any impact on performance?

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-02-16 11:09:59 Re: left outer join without rows from "left" table
Previous Message Ludwig Kniprath 2009-02-16 08:47:02 Re: ask: select right(column) ???