Re: Size estimation of postgres core files

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Size estimation of postgres core files
Date: 2019-02-15 18:18:54
Message-ID: CAMa1XUh8PF+20H-sU9M2S0MznbV1tNuA07whGN9A+jq=gM+zvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> In Linux, yes. Not sure about other OSes.
>
> You can turn off the dumping of shared memory with some unusably
> unfriendly bitwise arithmetic using the "coredump_filter" file in /proc
> for the process. (It's inherited by children, so you can just set it
> once for postmaster at server start time).
>

Yes Linux. This is very helpful, thanks. A follow-up question - will it
take postgres a really long time to crash (and hopefully recover) if I have
say 1T of RAM because it has to write that all out to a core file first?

Thanks,
Jeremy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andre Piwoni 2019-02-15 18:23:22 Promoted slave tries to archive previously archived WAL file
Previous Message Adrian Klaver 2019-02-15 18:05:34 Re: PostgreSql Version Compatibility With Apache ActiveMQ