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

Ron Johnson <ron.l.johnson@cox.net> writes:

> 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?

We just relocated the SAN volume.  Takes about 1 minute :-)

>
> -- 
> World Peace Through Nuclear Pacification

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general