Re: Performance of Query 4 on TPC-DS Benchmark - Mailing list pgsql-performance

From Ba Jinsheng
Subject Re: Performance of Query 4 on TPC-DS Benchmark
Date
Msg-id SEZPR06MB649467407B292F9979DFD6788A582@SEZPR06MB6494.apcprd06.prod.outlook.com
Whole thread Raw
In response to Re: Performance of Query 4 on TPC-DS Benchmark  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-performance

>> 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?


Aha, you are right. The error disappears if running PostgreSQL out of docker container.
Notice: This email is generated from the account of an NUS alumnus. Contents, views, and opinions therein are solely those of the sender.

pgsql-performance by date:

Previous
From: Ba Jinsheng
Date:
Subject: Re: Performance of Query 4 on TPC-DS Benchmark
Next
From: Tomas Vondra
Date:
Subject: Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4