From: Josh Berkus <josh@agliodbs.com>
To: Jason Hihn <jhihn@paytimepayroll.com>
To: pgsql-performance@postgresql.org
Subject: Re: Shopping for hardware
Date: Mon, 6 Oct 2003 09:33:27 -0700
Message-ID: <200310060933.27715.josh@agliodbs.com> (raw)
In-Reply-To: <NGBBLHANMLKMHPDGJGAPGEPECNAA.jhihn@paytimepayroll.com>
References: <NGBBLHANMLKMHPDGJGAPGEPECNAA.jhihn@paytimepayroll.com>
Jason,
> In terms of numbers, we expect have an average of 100 active connections
> (most of which are idle 9/10ths of the time), with about 85% reading
> traffic. I hope to have one server host about 1000-2000 active databases,
> with the largest being about 60 meg (no blobs). Inactive databases will
> only be for reading (archival) purposes, and will seldom be accessed. (I
> could probably move them off to another server with a r/o disk...)
Hey, two people (one of them me) suggested that rather than putting all 2000
databases on one $15,000 server, that you buy 3 $5000 servers and split
things up. You may have considered this suggestion and rejected it, but
I'mm wondering if you missed it ...
If you're lumping everything on one server, you'll need to remember to
increase max_fsm_relations to the total number of tables in all databases ...
for example, for 10 tables in 2000 databases you'll want a setting of 20000
(which sounds huge but it's really only about 1mb memory).
--
Josh Berkus
Aglio Database Solutions
San Francisco
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-performance@postgresql.org
Cc: josh@agliodbs.com, jhihn@paytimepayroll.com
Subject: Re: Shopping for hardware
In-Reply-To: <200310060933.27715.josh@agliodbs.com>
* 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