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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
