Thank you!
- Original Message -
From: Scott Marlowe
To: Midge Brown
Cc: pgsql-performance@postgresql.org
Sent: Saturday, August 20, 2011 9:01 PM
Subject: Re: [PERFORM] settings input for upgrade
On Thu, Aug 18, 2011 at 3:55 PM, Midge Brown wrote:
> Here are the change
On Thu, Aug 18, 2011 at 3:55 PM, Midge Brown wrote:
> Here are the changes I made to postgres.conf. The only differences between
> the conf file for DB1 and those for DB2 & 3 are the port and
> effective_cache_size (which I made slightly smaller -- 8 GB instead of 10 --
> for the 2 write-heavy DBs
Robert,
I was largely looking for input on whether I may have inadvertently shot myself
in the foot with some of the choices I made when setting up postgresql 9.0,
which is on different hardware than was the 7.4 setup.
The splitting of one table to two separate databases was done on 7.4 and di
On Thu, Aug 18, 2011 at 11:55 PM, Midge Brown wrote:
> I'm in the process of upgrading from postgres 7.4.8 to 9.0.4 and wanted to
> run my decisions past some folks who can give me some input on whether my
> decisions make sense or not.
I am not sure what decisions you actually refer to here: in
