select 'x' ~ repeat('x*y*z*', 1000);

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: select 'x' ~ repeat('x*y*z*', 1000);
Date: 2021-04-20 04:43:07
Message-ID: CA+hUKG+Va3AEjcU_vD6gQiAWeSm6bKxQEC8XmoohObpxYfcTZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Just an observation: on REL_13_STABLE, $SUBJECT maps in ~170MB of
memory, and on master it's ~204MB. A backend running that was just
nuked by the kernel due to lack of swap space on my tiny buildfarm
animal elver (a VM with 1GB RAM, 2GB swap, not doing much else).
Could also be related to an OS upgrade ~1 week ago. It's obviously
time to increase the VM size which is no problem, but I thought those
numbers were interesting.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yuya Watari 2021-04-20 04:43:28 Re: Performance Evaluation of Result Cache by using TPC-DS
Previous Message Kyotaro Horiguchi 2021-04-20 04:32:35 Stale description for pg_basebackup