Re: Migrate postgres to newer hardware

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.