rote:
On 11/12/24 20: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 tes
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
Στις 12/11/24 15:17, ο/η Tomas Vondra έγραψε:
On 11/12/24 11:37, Achilleas Mantzios - cloud wrote:
...
We run perf on both systems for 90 seconds to make sure that it included
at least two runs of the slow system, and we attach both outputs. We run
perf as :
sudo perf record -g -p -- sleep
Στις 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
Στις 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
Στις 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
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 16). Here is the bug report on github :
https://gi
in PostgreSQL
can't pass
inside a subquery. It could be a reason for new development because
MSSQL can do such a trick, but it is a long way.
You can try to rewrite your schema and query to avoid subqueries in
expressions at all.
I hope this message gave you some insights.
[1] https://github.com/postgrespro/aqo
--
regards, Andrei Lepikhov
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)
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
7;s libc in more cases
(and also agree with ICU).
Thank you Thomas , our linux's glibc is on version : 2.19-18+deb8u10, we
need to upgrade on so many levels.
[1]https://unicode.org/reports/tr10/#Synch_ISO14651
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
Στις 15/9/23 22:42, ο/η Tom Lane έγραψε:
Achilleas Mantzios writes:
Thank you, I see that both systems use en_US.UTF-8 as lc_collate and
lc_ctype,
Doesn't necessarily mean they interpret that the same way, though :-(
the below seems ok
FreeBSD :
postgres@[local]/dynacom=# select *
Στις 15/9/23 18:23, ο/η Tom Lane έγραψε:
Achilleas Mantzios - cloud writes:
*FreeBSD*
-> Index Only Scan using mail_vessel_addressbook_address_regex_idx
on mail_vessel_addressbook (cost=0.42..2912.06 rows=620 width=32)
(actual time=96.704..96.705 rows=1 loops=1)
Filter:
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
ns?
Say I have 150 queries in Postgres 11 and I want to upgrade to
Postgres 15. I want to run explain analyze for 150 in both versions
for comparative analysis.
I am looking for the easiest way to do it with a tool :)
--
Cheers,
Kunwar
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt
14 matches
Mail list logo
