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

2024-11-13 Thread Achilleas Mantzios - cloud
Dear All false alert, I run strace and it was obvious the slow one was producing huge debug output, while the fast one did not. It was not even a tds_fdw issue. It was freetds. Turned out we have forgotten enabled debugging inside the freetds configuration. You will ask me we did I get this e

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

2024-11-12 Thread Achilleas Mantzios - cloud
On 11/12/24 21:37, Tom Lane wrote: Achilleas Mantzios writes: Our sysadm created the system debian Debian GNU/Linux 12 (bookworm)with postgres as user 1000. Now at some point we realized that whenever we run a pgsql cluster with another user (I found that after spending two good days testing)

Re: Inconsistent query performance based on relation hit frequency

2024-06-27 Thread Achilleas Mantzios - cloud
On 6/27/24 03:50, Laura Hausmann wrote: Heya, I hope the title is somewhat descriptive. I'm working on a decentralized social media platform and have encountered the following performance issue/quirk, and would like to ask for input, since I'm not sure I missed anything. I'm running PostgreS

pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit

2023-09-15 Thread Achilleas Mantzios - cloud
Dear All I have a weird problem, I am trying to improve performance on this query : SELECT text('f...@bar.com') from mail_vessel_addressbook where text('f...@bar.com') ~* address_regex limit 1; The first system (linux) is a linux hosted in a cloud, kernel 3.16.0-4-amd64, 32GB mem, SSD, 4 x I