On 03/21/2012 12:31 PM, Kjetil Nygård wrote:
Hi,
We are considering to migrate some of our databases to PostgreSQL.
We wonder if someone could give some hardware / configuration specs for
large PostgreSQL installations...
You need to tell us a lot more than "large" (a speaker-dependent
description I've heard applied to 100,000 record databases up to
multi-terabyte).
For rough starting approximations how about:
-Estimated data size in GB and number of tuples
-Peak transactions/second required
-Max acceptable transaction latency
-Number of simultaneous connections required
-Nature of workload (OLAP, OLTP, primarily reads or writes)
-Nature of data - is it mostly "vanilla" int/date/text/etc. or is it
large blobs, full-text-search, GIS or the like?
-Maintenance window allowances (running business-hours only or 24x7)
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
