| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Kjetil Nygård <polpot78(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Large PostgreSQL servers |
| Date: | 2012-03-21 19:53:28 |
| Message-ID: | 4F6A31B8.1000101@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2012-03-21 19:56:15 | Re: Large PostgreSQL servers |
| Previous Message | Kjetil Nygård | 2012-03-21 19:50:00 | Re: Large PostgreSQL servers |