Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52271=pgsql-performance-ar@postgresql.org>)
 id 1XZydt-00038l-QN
 for pgsql-performance@arkaria.postgresql.org; Fri, 03 Oct 2014 08:55:13 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M52271=pgsql-performance-ar@postgresql.org>)
 id 1XZydt-0004Vq-9w
 for pgsql-performance@arkaria.postgresql.org; Fri, 03 Oct 2014 08:55:13 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <roberto.grandi@trovaprezzi.it>)
 id 1XZyds-0004Ut-4g
 for pgsql-performance@postgresql.org; Fri, 03 Oct 2014 08:55:12 +0000
Received: from mail.trovaprezzi.it ([2.228.21.217])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <roberto.grandi@trovaprezzi.it>) id 1XZydp-0007WP-BQ
 for pgsql-performance@postgresql.org; Fri, 03 Oct 2014 08:55:10 +0000
Received: from localhost (localhost [127.0.0.1])
 by mail.trovaprezzi.it (Postfix) with ESMTP id 9B0C9E80EC
 for <pgsql-performance@postgresql.org>;
 Fri,  3 Oct 2014 10:55:05 +0200 (CEST)
Received: from mail.trovaprezzi.it ([127.0.0.1])
 by localhost (zimbra.7pixel.local [127.0.0.1]) (amavisd-new, port 10032)
 with ESMTP id wbNpWsty5gGL for <pgsql-performance@postgresql.org>;
 Fri,  3 Oct 2014 10:55:05 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1])
 by mail.trovaprezzi.it (Postfix) with ESMTP id 0FDCAE8224
 for <pgsql-performance@postgresql.org>;
 Fri,  3 Oct 2014 10:55:05 +0200 (CEST)
X-Virus-Scanned: amavisd-new at zimbra.7pixel.local
Received: from mail.trovaprezzi.it ([127.0.0.1])
 by localhost (zimbra.7pixel.local [127.0.0.1]) (amavisd-new, port 10026)
 with ESMTP id o_ITs_ROpWYn for <pgsql-performance@postgresql.org>;
 Fri,  3 Oct 2014 10:55:04 +0200 (CEST)
Received: from zimbra.7pixel.local (zimbra.7pixel.local [192.168.0.127])
 by mail.trovaprezzi.it (Postfix) with ESMTP id E8A65E80EC
 for <pgsql-performance@postgresql.org>;
 Fri,  3 Oct 2014 10:55:04 +0200 (CEST)
Date: Fri, 3 Oct 2014 10:55:04 +0200 (CEST)
From: Roberto Grandi <roberto.grandi@trovaprezzi.it>
To: pgsql-performance@postgresql.org
Message-ID: <1722782443.6266128.1412326504755.JavaMail.zimbra@trovaprezzi.it>
In-Reply-To: <1705399839.6266050.1412326345164.JavaMail.zimbra@trovaprezzi.it>
Subject: Planning for Scalability
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Originating-IP: [91.204.80.113]
X-Mailer: Zimbra 8.0.6_GA_5922 (ZimbraWebClient - FF32 (Win)/8.0.6_GA_5922)
Thread-Topic: Planning for Scalability
Thread-Index: I71vkbtNKxALb0Wh+momQ6iwtcWGZw==
X-Pg-Spam-Score: 0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Dear Pg people,

I would ask for your help considering this scaling issue. We are planning to move from 3Millions of events/day instance of postgres (8 CPU, 65 gb ram) to 5 millions of items/day.
What do you suggest in order to plan this switch? Add separate server? Increase RAM? Use SSD?

Any real help will be really precious and appreciated.
Roberto


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance