Re: Postgres Query Plan using wrong index

David Rowley writes: > On Thu, 3 Apr 2025 at 16:24, Manikandan Swaminathan > wrote: >> why doesn’t making a multivariate statistic make a difference? > Extended statistics won't help you here. "dependencies" just estimates > functional dependencies between the columns mentioned in the ON > claus

Re: Any industry best practise to overcome this specific malware "pg_mem"

On 4/2/25 08:18, Bharani SV-forum wrote: Hello MVP's Good Morning Any industry best practise to overcome this specific malware "pg_mem". url = https://www.aquasec.com/blog/pg_mem-a-malware-hidden-in-the-postgres-processes/

Re: Issue installing postgis on RHEL9

I have confirmed that the package installs successfully, thank you! On Wed, Apr 2, 2025 at 1:48 PM Devrim Gündüz wrote: > Hi, > > On Wed, 2025-04-02 at 11:29 -0500, Danny Im wrote: > > Problem: package postgis30_13-3.0.7-1.rhel9.x86_64 from postgresql > > requires gdal33-libs >= 3.3.3, but none

Re: Postgres Query Plan using wrong index

Manikandan Swaminathan writes: > 1) Why is the query currently picking the poorly performing index? Because the planner thinks that one will be cheaper, as you can see by comparing the cost estimates in EXPLAIN. It's wrong, but this is a hard problem to estimate well. Especially when the behavi

Re: Postgres Query Plan using wrong index

On Thu, 3 Apr 2025 at 16:24, Manikandan Swaminathan wrote: > Since you mentioned the planner not knowing about the correlation between the > columns, I’m curious, why doesn’t making a multivariate statistic make a > difference? > > > CREATE STATISTICS col_a_col_b_stats (dependencies) ON col_a, c

Re: Performance issues during pg_restore -j with big partitioned table

On 4/2/25 10:32 AM, Dimitrios Apostolou wrote: Hello list. My database includes one table with 1000 partitions, all of them rather sizeable. I run:   pg_restore -j12 --no-tablespaces --disable-triggers --exit-on-error --no-owner --no-privileges -n public -d newdb custom_format_dump.pgdump

Re: Performance issues during pg_restore -j with big partitioned table

On Wed, 2 Apr 2025, Adrian Klaver wrote: On 4/2/25 10:32 AM, Dimitrios Apostolou wrote: Hello list. My database includes one table with 1000 partitions, all of them rather sizeable. I run:   pg_restore -j12 --no-tablespaces --disable-triggers --exit-on-error --no-owner --no-privileges

Re: Issue installing postgis on RHEL9

On Wed, Apr 2, 2025 at 12:29 PM Danny Im wrote: > Hello, > > I am having issues trying to install the postgis30_13 package on a RHEL9 > host. Attempting to install the package gives me this error: > > $ sudo dnf install postgis30_13 > Updating Subscription Management repositories. > Zabbix 6.0 LT

Re: Performance issues during pg_restore -j with big partitioned table

On Wed, 2 Apr 2025, Adrian Klaver wrote: On 4/2/25 10:39 AM, Adrian Klaver wrote: --clean will drop the object entirely not TRUNCATE. I'm guessing that this is being done by you per: https://www.postgresql.org/message-id/53760c70-4a87-a453-9e02-57abc9cb2e54%40gmx.net "After each fa

Re: Issue installing postgis on RHEL9

It doesn't look like it. I tried to find what provides libarmadillo.so.10 but could not find any packages: $ sudo dnf provides */libarmadillo.so.10 Updating Subscription Management repositories. Last metadata expiration check: 0:20:05 ago on Wed Apr 2 11:17:43 2025. Error: No matches found. If s

Re: Issue installing postgis on RHEL9

Hi, On Wed, 2025-04-02 at 11:29 -0500, Danny Im wrote: > Problem: package postgis30_13-3.0.7-1.rhel9.x86_64 from postgresql > requires gdal33-libs >= 3.3.3, but none of the providers can be > installed >   - package postgis30_13-3.0.7-1.rhel9.x86_64 from postgresql requires > libgdal.so.29()(64bit