Re: Up to date conventional wisdom re max shared_buffer size?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Up to date conventional wisdom re max shared_buffer size?
Date: 2017-09-20 01:47:45
Message-ID: dfb3e2d5-e9ee-7cef-2d16-c2b41726bbc7@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/19/2017 05:00 PM, Jerry Sievers wrote:
[snip]
> The DB is 10TB total size with OLTP plus some occasional heavy batching
> which frequently correlates with degradation that requires intervention.
>
> Unrelated server problem forced us to relocate from a Debian/Wheezy 3.x
> kernel 1T 144 CPU to the even bigger box mentioned earlier. And we wen
> up a major kernel version also in the process.

How did you backup/restore a 10TB db?

--
World Peace Through Nuclear Pacification

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Samad 2017-09-20 01:59:20 problem
Previous Message Stephen Cook 2017-09-20 01:37:39 Re: pgcrypto encrypt