| From: | Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> |
|---|---|
| To: | Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Greg Smith <greg(at)2ndquadrant(dot)com>, Tino Schwarze <postgresql(at)tisc(dot)de>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Migrate postgres to newer hardware |
| Date: | 2010-03-31 12:27:56 |
| Message-ID: | 1270038476.5155.230.camel@bnicholson-desktop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lst_hoe02 | 2010-03-31 13:19:24 | Re: Any good olap benchmarks? |
| Previous Message | Guillaume Lelarge | 2010-03-31 12:26:47 | Re: Statistics Collector not collecting server activities |