From: Ba Jinsheng <bajinsheng@u.nus.edu>
To: Thomas Munro <thomas.munro@gmail.com>
CC: "pgsql-performance@lists.postgresql.org"
	<pgsql-performance@lists.postgresql.org>
Subject: Re: Performance of Query 4 on TPC-DS Benchmark
Thread-Topic: Performance of Query 4 on TPC-DS Benchmark
Thread-Index: AQHbM53XJabm3wvFF0icxJuGGZYSB7Kw7q6AgAD5BL0=
Date: Mon, 11 Nov 2024 10:51:16 +0000
Message-ID: 
 <SEZPR06MB649467407B292F9979DFD6788A582@SEZPR06MB6494.apcprd06.prod.outlook.com>
References: 
 <SEZPR06MB6494F6A2837995BDD4E0BF9A8A5F2@SEZPR06MB6494.apcprd06.prod.outlook.com>
 <CA+hUKGLFYtvn=BRi3ERS9HMm5tDX=45HLHhn4jswDK43qgJfwg@mail.gmail.com>
In-Reply-To: 
 <CA+hUKGLFYtvn=BRi3ERS9HMm5tDX=45HLHhn4jswDK43qgJfwg@mail.gmail.com>
Accept-Language: en-US, en-SG
Content-Language: en-US
msip_labels: 
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=u.nus.edu;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: SEZPR06MB6494:EE_|SEZPR06MB7291:EE_
x-ms-office365-filtering-correlation-id: 2e47e45f-3cff-4fd2-c39b-08dd023ec470
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|1800799024|376014|366016|8096899003|38070700018;
x-microsoft-antispam-message-info: 
 =?iso-8859-1?Q?vzKKHyqgvxbBxbTJjUt9b9TNTyKe3NwwwjBTIS4y/LceIFo7a5iyiWSrf3?=
 =?iso-8859-1?Q?srh9croBDHTp8Q6TCvPrZ3miAkbl6QJsjsx6O6IwLw9UE3ULR83rYl88gE?=
 =?iso-8859-1?Q?JaRPt0QwFJWDKp6CPYzOdJLBjkRAqoGux4Xx+bXV2dOgsbuwKCln0AjvFJ?=
 =?iso-8859-1?Q?0uaO7lugaWdwF+dqg2IQ3JiUkDW+tyM36511grrGoYi60qobtIfyyCkCgs?=
 =?iso-8859-1?Q?aTytKCEZyWUXCPH7beHVF9C0yPIaOjo6u9i/nTwkGAVB4ii1IK5AAXGyiE?=
 =?iso-8859-1?Q?3PCD5dVFyxaKBw4MFayRrqoNDiv51OZQObnzJOB2kUulM1P3HxfmYUd+0J?=
 =?iso-8859-1?Q?ilvNfKVreY2vRR0yoPYfQhxLahsE4SCBqhpqvzTHzhCU1ds5FyCSJK/g4A?=
 =?iso-8859-1?Q?f62dfk1XYcfNtZoAmMk/ZhrN8BiYinpA1hVgDGW7Sg1W1Su1gLN5cCt0Ja?=
 =?iso-8859-1?Q?orQJ0ond1FmfBxRdVCeyscD+mDEgfRarwvZ+X0gxo750/iCme5FlBkNU01?=
 =?iso-8859-1?Q?meaBYE7RZB8h1gd6EWrLTLxr7Au6YRA2ndjxUGrQEqxAMQfG15s3suniF5?=
 =?iso-8859-1?Q?vIJfbfn8XvO+xDHWP08p6Lmf0musLf6N2aS1rR5zNw6ItcY0MzrJZFB0HX?=
 =?iso-8859-1?Q?ZiSAsjby6dEiITaKEBgIyujawmsoKPTCUfy8loGCwNChcpq+oh4izWUBfb?=
 =?iso-8859-1?Q?auiP7bF3RRzkzqwBSzz6izEuFnASuICFrZ/AFDpUMUsF/zAz+vG2M8fOZV?=
 =?iso-8859-1?Q?y11kdF5fn2noWb2bwTvgVQe+u+wyNo6l0eIQVq7Bg0lWVtoAE8BUmqVMHp?=
 =?iso-8859-1?Q?HK1N5Z0gXXPy6NM+E57viMqwJCM3OMsFRXCxv/+mWPat0TcfAJUmqUZ8Nh?=
 =?iso-8859-1?Q?SCNTRqPIazn51HsM4NMYpW8TxlOCCn13z1auAbGRyEDp87jR3DlUxK6yje?=
 =?iso-8859-1?Q?bNi2BPKU1P0r6+rTIVORrP7Vuc3kdeJCZ+vNB05r1t2tDIuJF8eNT9M1pE?=
 =?iso-8859-1?Q?VP1QvY66R8gM4ISt17qesJde2D0GtNdJRo6SmQSVCBXSrwoPaYGWoehPT7?=
 =?iso-8859-1?Q?TPB0Ks9EEe7Y+EyxjVso39cf0cIjxuG7z2b7LqYzEtIppCb+SPLTz94tad?=
 =?iso-8859-1?Q?bgk9i7i6RMuhBguaLt+U5dJ5l0NFBHEDaXsXReQleq93M6lfHuAp1RS7GC?=
 =?iso-8859-1?Q?I3cjzHAmoI9xeEXe16aXmZxzniXGYlQ2/mU/wY6yPD1btzMWmiTIhFHDCx?=
 =?iso-8859-1?Q?wdrd/UdmML9fIIqli50nuDm2NAu4330GGGqL4KJZPcc1Z7aTCm7EptTwuy?=
 =?iso-8859-1?Q?XbJTshdc6MmhL4SSLEqdwDm/mtK/VuixncE9/mwXmm2OgiTLK1GUobybCK?=
 =?iso-8859-1?Q?M53Hz7OKlwxmOHKJ//9zSZRwUzoUnKTWBIjpH4xQ6tmPUqEPCopLc=3D?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SEZPR06MB6494.apcprd06.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(8096899003)(38070700018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?WN1d9aEB6l5xWRhCeIzBYHXsMUKGYi8+IS76Lv35/VEdrQz1U66KzuuMtd?=
 =?iso-8859-1?Q?jJItCwnPng/8bnwcnvpSI3qh9chto6H+8ubB9lc2rl+qRgua8WmJK/DXRI?=
 =?iso-8859-1?Q?bfLVthfvTQs8ltNrCraGtyxfWCJLd0i+C7or76guWVwDVhRlVCDNwrT3aU?=
 =?iso-8859-1?Q?robODuJ5tj8wlMFRPbG7uOTHTch+gDK/zY/qYar/BXlEoHF3S9LGq3smHT?=
 =?iso-8859-1?Q?unCqdCO29AETexrYbdj+jraDmpFMqGQNxnyNaqMADmAKTyAgZ+fwEhGGjU?=
 =?iso-8859-1?Q?rDh8YCDDLVJ3H9cKHDQ9WOusbWbeuUy1ep0N1phckde90stX98WZCOCh+s?=
 =?iso-8859-1?Q?xRjZwndDpmH0/87yoTUE4/g7WyPKRmtMDrGOqudANHM6Tdm2K7W8+A5gQ3?=
 =?iso-8859-1?Q?rohJ6YeBEQ1++KVzTqW8gbV2djHvDvqsxLC3NnLZPALCQXX5ZbUcclT1vJ?=
 =?iso-8859-1?Q?7mpRIlQT4C7AeocKJFmgg04SnJf8FteyAo/m7M0bcdRUZklPT2ZbMIzAwd?=
 =?iso-8859-1?Q?PXkaUgi6R3OQNarN0lDhsYRFjUVlT6iboix1AdG2eG2nF2lbEY6XW/+6AC?=
 =?iso-8859-1?Q?/XpPJ7VOPU9gzL6rTtb90Yl4Zb1mtTWrukYVQntFDviolZ8AxIXcmrZC/3?=
 =?iso-8859-1?Q?SHwQFejHegQA3Rlq7i3npxXqpYdzcuMDWJ83BrX+98Wv1aCaKScBkW1xKH?=
 =?iso-8859-1?Q?R2PW3JOgDBmmW2hnrtCljgJJnLTm0o7G1AzLDs2Z111ckyh6EEJQ+mb7Q2?=
 =?iso-8859-1?Q?xVVzJosX46XcOrJiC2+BPZR5+hqnoUl88RT+9FYfWGJl9QRepsl+/AY5F4?=
 =?iso-8859-1?Q?6VvFv5DR9DEBRbCIF5hmVwipALVC03QYV0qUPHNP93qSLf/O2PUFCvxdp+?=
 =?iso-8859-1?Q?l2gwHOffZYQXKIYUa9PAgFU6h4sQLLaY6P+6UwCxupxoMHVniHsn1CimYU?=
 =?iso-8859-1?Q?CnHl6rjJClIpprK38AwfOhAZ2TfnV7yaFxPb/NlIqtEg+34m6qAVDjtjhs?=
 =?iso-8859-1?Q?CCDrkQcSGXPxbAPoR5M9ZoB9GtgxvPFwM7rnPGior98nPhGf6ijeRoGI7R?=
 =?iso-8859-1?Q?BHlBIT8841D1edWN3+4uYrDbTf4VWQyZ5JhkeudAAIgmzE5l641+3ggW5n?=
 =?iso-8859-1?Q?bKzkVVs4SVHpfg/MPE+ghCv/eJbcshGApotHDdxcaXYy23Oxct9r5mdWuv?=
 =?iso-8859-1?Q?Jv43HHGeFpiBAtPFpTyHB0npdveTuD7FgUuqYgHshPwVG2Bk8YMiGxWRbw?=
 =?iso-8859-1?Q?6+XJBIOg4NU1USz/Uwkr6jbkSK3UeF8qHDjztW0fvEh6rKaggKzRjaR0+i?=
 =?iso-8859-1?Q?H+S7YLzBDpiZyOH1nP/B+/EK8oCCYJ9YqQ7DtqdvYJTB7hx2nkGYj+uoG6?=
 =?iso-8859-1?Q?CcUnm17MX87A8pHayjaXrwKElcOb3z7IrYJFktv8pQ7hC21rszgj5bh7uR?=
 =?iso-8859-1?Q?GQ2PatNlrDZAKTAk32xI0nGxYn6ZDSjPs2ey/h0SVG1rYjpfNnxkKzwjh1?=
 =?iso-8859-1?Q?b64pDRlyxfppsNPCtH31bOCGN0F/l2e7g2lczCzt70p8Y0eRl8u2F5i/za?=
 =?iso-8859-1?Q?oq5ZZbmF8LGnt+dPTjLFu2xYbX4nD0yyFtg7y5oMIPgc8f00WSWMWSsu0I?=
 =?iso-8859-1?Q?//CvnGGa4fgU4=3D?=
Content-Type: multipart/alternative;
	boundary="_000_SEZPR06MB649467407B292F9979DFD6788A582SEZPR06MB6494apcp_"
MIME-Version: 1.0
X-OriginatorOrg: u.nus.edu
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SEZPR06MB6494.apcprd06.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 2e47e45f-3cff-4fd2-c39b-08dd023ec470
X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Nov 2024 10:51:16.3056
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 5ba5ef5e-3109-4e77-85bd-cfeb0d347e82
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 lA31oJ3KYpyfpDFm0Fy3hZsKh6ppNrCzihUSQE98HTF+X9LtyBLUjVWeeHmIsKtIt8gRYk66al4s4DXxwk+yow==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SEZPR06MB7291
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Archived-At: 
 <https://www.postgresql.org/message-id/SEZPR06MB649467407B292F9979DFD6788A582%40SEZPR06MB6494.apcprd06.prod.outlook.com>
Precedence: bulk

--_000_SEZPR06MB649467407B292F9979DFD6788A582SEZPR06MB6494apcp_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


>> 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 docke=
r container.
Notice: This email is generated from the account of an NUS alumnus. Content=
s, views, and opinions therein are solely those of the sender.

--_000_SEZPR06MB649467407B292F9979DFD6788A582SEZPR06MB6494apcp_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
<br>
&gt;&gt; The default configurations of PostgreSQL incur the error: &quot;ER=
ROR:&nbsp; could not resize shared memory segment &quot;/PostgreSQL.3539600=
020&quot; to 2097152 bytes: No space left on device&quot;<br>
<br>
&gt;No comment on your optimiser experiments for now, but for this error:<b=
r>
&gt;it reminds me of a low/default --shm-size limit from Docker, or other<b=
r>
&gt;similar container stuff?</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 11pt; c=
olor: rgb(0, 0, 0);">
Aha, you are right. The error disappears if running PostgreSQL out of docke=
r container.</div>
Notice: This email is generated from the account of an NUS alumnus. Content=
s, views, and opinions therein are solely those of the sender.
</body>
</html>

--_000_SEZPR06MB649467407B292F9979DFD6788A582SEZPR06MB6494apcp_--