| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to tune my new server |
| Date: | 2015-08-18 18:44:54 |
| Message-ID: | 55D37D26.8070008@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/18/2015 6:33 AM, Joseph Kregloh wrote:
> Of course not every machine is built the same and not every PostgreSQL
> server is used the same, to tune according to the machine and the
> usage of the server.
>
indeed, your use case heavily affects the optimal decisions, there's no
one-size-fits-all answer. are you doing OLTP, characterized by
frequent small transactions with high percentage of update events and
many clients, or is this OLAP, where you bulk load large data, then do
relatively few very large aggregate type queries for reporting purposes ?
--
john r pierce, recycling bits in santa cruz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter J. Holzer | 2015-08-18 20:59:37 | Re: Upgrade from postgresql-9.5alpha1 to postgresql-9.5alpha2 (Debian packages) |
| Previous Message | Alvaro Herrera | 2015-08-18 18:02:07 | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |