Re: Performance of Query 4 on TPC-DS Benchmark

2024-11-10 Thread Alena Rybakina
On 10.11.2024 23:16, Alena Rybakina wrote: Hi! On 10.11.2024 22:35, Ba Jinsheng wrote: Hi all, Please see this case: Query 4 on TPC-DS benchmark: with year_total as (  select c_customer_id customer_id        ,c_first_name customer_first_name        ,c_last_name customer_last_name        ,c

Re: Performance of Query 4 on TPC-DS Benchmark

2024-11-10 Thread Alena Rybakina
Hi! On 10.11.2024 22:35, Ba Jinsheng wrote: Hi all, Please see this case: Query 4 on TPC-DS benchmark: with year_total as (  select c_customer_id customer_id        ,c_first_name customer_first_name        ,c_last_name customer_last_name        ,c_preferred_cust_flag customer_preferred_cust_

Re: Performance of Query 4 on TPC-DS Benchmark

2024-11-10 Thread Thomas Munro
On Mon, Nov 11, 2024 at 8:36 AM Ba Jinsheng 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 e

Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4

2024-11-10 Thread Achilleas Mantzios
Στις 9/11/24 17:41, ο/η Tomas Vondra έγραψε: On 11/9/24 15:05, Achilleas Mantzios wrote: Στις 9/11/24 12:49, ο/η Tomas Vondra έγραψε: On 11/8/24 20:32, Achilleas Mantzios wrote: Dear All, we have hit a serious performance regression going from 10.23 → 16.4 as far as tds_fdw (MS SQL) FDW is