| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Issues shutting down PostgreSQL 10 cleanly |
| Date: | 2017-10-24 06:27:29 |
| Message-ID: | CANP8+j+V0YdpHrajLm9TmHMVb6Lq=f6nE5pU=X-v0RnjbUPb+Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 23 October 2017 at 15:23, Stephen Froehlich
<s(dot)froehlich(at)cablelabs(dot)com> wrote:
> I am in the midst of heavy, large write operations on a new database this is
> currently around 23 billion lines.
>
> My max_wal_size is 256 GB and my checkpoint_timeout is 12 hours. (Smaller
> values were hindering the writes.) Note: this is on Ubuntu 16.04 LTS.
>
> I am having trouble shutting down postgres cleanly – how can I fix that?
The time to shutdown will be longer than normal with those settings.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2017-10-24 06:27:46 | Re: New Version Errors |
| Previous Message | Laurenz Albe | 2017-10-24 06:20:19 | Re: Issues shutting down PostgreSQL 10 cleanly |