| From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
|---|---|
| To: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Up to date conventional wisdom re max shared_buffer size? |
| Date: | 2017-09-20 18:05:37 |
| Message-ID: | 87wp4tw8i6.fsf@jsievers.enova.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2017-09-20 18:14:14 | Any known issues Pg 9.3 on Ubuntu Xenial kernel 4.4.0? |
| Previous Message | Thomas Delrue | 2017-09-20 18:03:26 | Re: libpq confusion |