Re: out of memory in crosstab()

2022-11-16 Thread Joe Conway
On 11/16/22 02:47, Amit Langote wrote: A customer seems to have run into $subject. Here's a reproducer they shared: With the following logged: LOG: server process (PID 121846) was terminated by signal 9: Killed That's the Linux OOM killer. Was this running in a container or under

out of memory in crosstab()

2022-11-15 Thread Amit Langote
Hi, A customer seems to have run into $subject. Here's a reproducer they shared: CREATE TABLE test (id integer, category integer, rate numeric); INSERT INTO test SELECT x.id, y.category, random() * 10 AS rate FROM generate_series(1, 100) AS x(id) INNER JOIN generate_series(1,