Postgres Pro
Downloads
Home   >   mailing lists

select 'x' ~ repeat('x*y*z*', 1000); - Mailing list pgsql-hackers

From Thomas Munro
Subject select 'x' ~ repeat('x*y*z*', 1000);
Date
Msg-id CA+hUKG+Va3AEjcU_vD6gQiAWeSm6bKxQEC8XmoohObpxYfcTZA@mail.gmail.com
Whole thread Raw
Responses Re: select 'x' ~ repeat('x*y*z*', 1000);  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
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.

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Stale description for pg_basebackup
Next
From: Yuya Watari
Date:
Subject: Re: Performance Evaluation of Result Cache by using TPC-DS