pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Brad Nicholson <bnichols@ca.afilias.info>
To: Renato Oliveira <renato.oliveira@grant.co.uk>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Migrate postgres to newer hardware
Date: Wed, 31 Mar 2010 08:27:56 -0400
Message-ID: <1270038476.5155.230.camel@bnicholson-desktop> (raw)
In-Reply-To: <7965A9DCF12CC14984420BCC37B1608F25AB1AEF32@Elzar.grant.co.uk>
References: <7965A9DCF12CC14984420BCC37B1608F25AB1AED49@Elzar.grant.co.uk>
	<1269959369.15416.5.camel@deimos>
	<20100330143831.GE17567@easy5.in-chemnitz.de>
	<7965A9DCF12CC14984420BCC37B1608F25AB1AEE54@Elzar.grant.co.uk>
	<4BB22F64.8080708@2ndquadrant.com>
	<7965A9DCF12CC14984420BCC37B1608F25AB1AEF03@Elzar.grant.co.uk>
	<r2kdcc563d11003310111h7a0b742av18ff953d33d2d6ea@mail.gmail.com>
	<7965A9DCF12CC14984420BCC37B1608F25AB1AEF32@Elzar.grant.co.uk>

On Wed, 2010-03-31 at 09:22 +0100, Renato Oliveira wrote:
> Greg,
> 
> I am going to gather the figures about our database and I will email to the list, if I am allowed to.
> Number of tables, number of transactions per day etc.

Absolutely allowed, and encouraged. 

Also, do you have long running transactions against the database?  Are
you committing large numbers of writes in a single transaction?

> Nothing on our db servers are optimized, hardware wise, the db is on the same volume as logs as the os.
> I know we have an IO problem because I have been checking it and it has been growing steadily.
> We must migrate to newer and better optimized hardware.

That will be your sticking point with Slony.  If your IO system is
already taxed, Slony will just add to the burden.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.





view thread (34+ messages)  latest in thread

Message-ID: <1270038476.5155.230.camel@bnicholson-desktop>
Permalink:  ../1270038476.5155.230.camel@bnicholson-desktop/
Also on:    postgresql.org/message-id/1270038476.5155.230.camel@bnicholson-desktop

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: bnichols@ca.afilias.info, renato.oliveira@grant.co.uk, scott.marlowe@gmail.com, greg@2ndquadrant.com, postgresql@tisc.de
  Subject: Re: Migrate postgres to newer hardware
  In-Reply-To: <1270038476.5155.230.camel@bnicholson-desktop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox