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

2024-11-09 Thread 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 concerned. To cut the long

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

2024-11-09 Thread Achilleas Mantzios
Στις 9/11/24 16:05, ο/η Achilleas Mantzios έγραψε: Στις 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 concerned. To cut the long story shor

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

2024-11-09 Thread Achilleas Mantzios
Στις 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 concerned. To cut the long story short, I recreated the good fast “old” (pgsql 10) setup on

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

2024-11-09 Thread 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 concerned. To cut the long story short, I > recreated the good fast “old” (pgsql 10) setup on the same vm as the > slow “new” (pgsql