Re: Migrate postgres to newer hardware

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Renato Oliveira <renato(dot)oliveira(at)grant(dot)co(dot)uk>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(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 16:47:38
Message-ID: 4BB37CAA.90606@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Renato Oliveira wrote:
> 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.
>

A quick snapshot from "vmstat 1" during a busy time is also very helpful.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Igor Neyman 2010-03-31 19:16:45 Re: Live sort-of-'warehousing' database how-to?
Previous Message Tom Lane 2010-03-31 14:28:31 Re: Statistics Collector not collecting server activities