Обсуждение: Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

Поиск
Список
Период
Сортировка

Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

От
PG Doc comments form
Дата:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/kernel-resources.html
Description:

Hi.

On https://www.postgresql.org/docs/12/kernel-resources.html, the command to
calculate memory allocated to postgres is not correct. Following is the
command as shown in 18.4.5. Linux Huge Pages.

pmap 4170 | awk '/rw-s/ && /zero/ {print $2}', this command does not return
any results with correct pid. Probably /zero/ needs to be updated with
/anon_hugepage/

Thanks,
Sanjeev Adwal

Re: Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

От
Tom Lane
Дата:
PG Doc comments form <noreply@postgresql.org> writes:
> On https://www.postgresql.org/docs/12/kernel-resources.html, the command to
> calculate memory allocated to postgres is not correct. Following is the
> command as shown in 18.4.5. Linux Huge Pages.
> pmap 4170 | awk '/rw-s/ && /zero/ {print $2}', this command does not return
> any results with correct pid. Probably /zero/ needs to be updated with
> /anon_hugepage/

The example seems to work as-given for me (testing on a RHEL8 system).
It's of course not guaranteed to work on every flavor of Linux.

            regards, tom lane



Re: Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

От
Thomas Munro
Дата:
On Wed, Oct 6, 2021 at 3:48 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> PG Doc comments form <noreply@postgresql.org> writes:
> > On https://www.postgresql.org/docs/12/kernel-resources.html, the command to
> > calculate memory allocated to postgres is not correct. Following is the
> > command as shown in 18.4.5. Linux Huge Pages.
> > pmap 4170 | awk '/rw-s/ && /zero/ {print $2}', this command does not return
> > any results with correct pid. Probably /zero/ needs to be updated with
> > /anon_hugepage/
>
> The example seems to work as-given for me (testing on a RHEL8 system).
> It's of course not guaranteed to work on every flavor of Linux.

I think the pattern as given will show you the size if you are not
already using huge pages.  For example, this line matches on my system
when I have /proc/sys/vm/nr_hugepages == 0:

00007f2932eb6000 145360K rw-s- zero (deleted)

If you are already using huge pages, it doesn't match anything,
because the relevant line looks like:

00007f6814e00000 145408K rw-s- anon_hugepage (deleted)



Re: Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

От
Sanjeev Adwal
Дата:
Thanks Thomas. Looks like I misread that.

On Wednesday, 6 October, 2021, 04:56:42 am IST, Thomas Munro <thomas.munro@gmail.com> wrote:


On Wed, Oct 6, 2021 at 3:48 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> PG Doc comments form <noreply@postgresql.org> writes:
> > On https://www.postgresql.org/docs/12/kernel-resources.html, the command to
> > calculate memory allocated to postgres is not correct. Following is the
> > command as shown in 18.4.5. Linux Huge Pages.
> > pmap 4170 | awk '/rw-s/ && /zero/ {print $2}', this command does not return
> > any results with correct pid. Probably /zero/ needs to be updated with
> > /anon_hugepage/
>
> The example seems to work as-given for me (testing on a RHEL8 system).
> It's of course not guaranteed to work on every flavor of Linux.


I think the pattern as given will show you the size if you are not
already using huge pages.  For example, this line matches on my system
when I have /proc/sys/vm/nr_hugepages == 0:

00007f2932eb6000 145360K rw-s- zero (deleted)

If you are already using huge pages, it doesn't match anything,
because the relevant line looks like:

00007f6814e00000 145408K rw-s- anon_hugepage (deleted)