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

Reply via email to