Re: Performance of Query 4 on TPC-DS Benchmark

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Ba Jinsheng <bajinsheng(at)u(dot)nus(dot)edu>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>, "lepihov(at)gmail(dot)com" <lepihov(at)gmail(dot)com>
Subject: Re: Performance of Query 4 on TPC-DS Benchmark
Date: 2024-11-10 19:58:49
Message-ID: CA+hUKGLFYtvn=BRi3ERS9HMm5tDX=45HLHhn4jswDK43qgJfwg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Nov 11, 2024 at 8:36 AM Ba Jinsheng <bajinsheng(at)u(dot)nus(dot)edu> wrote:
> The default configurations of PostgreSQL incur the error: "ERROR: could not resize shared memory segment "/PostgreSQL.3539600020" to 2097152 bytes: No space left on device"

No comment on your optimiser experiments for now, but for this error:
it reminds me of a low/default --shm-size limit from Docker, or other
similar container stuff?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alena Rybakina 2024-11-10 20:16:48 Re: Performance of Query 4 on TPC-DS Benchmark
Previous Message Ba Jinsheng 2024-11-10 19:35:36 Performance of Query 4 on TPC-DS Benchmark