Re: UPDATE with multiple WHERE conditions

2024-06-12 Thread Muhammad Salahuddin Manzoor
Greetings, You can use Temporary table. You could create a temporary table with one column containing the condition values and then use it to update your main table. This approach can be more flexible and cleaner than writing a script with multiple update statements. -- Create a temporary table

Bugs details.

2024-06-04 Thread Muhammad Salahuddin Manzoor
Greetings, I need to get detailed information about PG bugs and fixes. I can get the information about new features and Fixes in the release document but I find only descriptions for each fix. I need detailed information about these fixes. How can I get details about the fix. Suppose the

Re: Unable to connect to any data source for foreign server

2024-05-29 Thread Muhammad Salahuddin Manzoor
Greetings, While configuring ORG_FWD. I hope you are setting path like server name and absolute path to file on your network share and network share has appropriate permissions. '\\remote_server\path\to\file.xlsx' on network share Create user mapping if required. check your config through

Re: Memory issues with PostgreSQL 15

2024-05-29 Thread Muhammad Salahuddin Manzoor
Greetings, The error message you encountered, "could not fork autovacuum worker process: Cannot allocate memory," indicates that your PostgreSQL server attempted to start an autovacuum worker process but failed because the system ran out of memory. Steps to verify. 1 Check system available

Re: prevent users from SELECT-ing from pg_roles/pg_database

2024-05-24 Thread Muhammad Salahuddin Manzoor
Greetings, Yes, you are correct. And For applications/systems/scripts relying on this information may require sgnificent modifications to handle the restricted access. Alternative approches can be. Auditing and monitoring. You can use pgaudit extension for auditing and minitoring. Use

Re: prevent users from SELECT-ing from pg_roles/pg_database

2024-05-24 Thread Muhammad Salahuddin Manzoor
Greetings, To prevent a user or role from selecting data from certain system tables in PostgreSQL, you can revoke the default select permissions on those tables. Here’s how you can do it: 1. Revoke SELECT permission on the system tables from the public role. 2. Grant SELECT permission only

Re: Long running query causing XID limit breach

2024-05-23 Thread Muhammad Salahuddin Manzoor
n XID limit saturation and thus causing system > failure. Hope my understanding is correct here. > > On Thu, May 23, 2024 at 11:41 AM sud wrote: > >> >> On Thu, May 23, 2024 at 10:42 AM Muhammad Salahuddin Manzoor < >> salahuddi...@bitnine.net> wrote: >> >>&g

Re: Long running query causing XID limit breach

2024-05-22 Thread Muhammad Salahuddin Manzoor
n Thu, May 23, 2024 at 9:00 AM Muhammad Salahuddin Manzoor < > salahuddi...@bitnine.net> wrote: > >> Greetings, >> >> In high-transaction environments like yours, it may be necessary to >> supplement this with manual vacuuming. >> >> Few Recommendations &g

Re: Json table/column design question

2024-05-22 Thread Muhammad Salahuddin Manzoor
Greetings, Storing unrelated JSON objects in the same table with distinct columns for each type (e.g., "Users" and "Inventory") is generally not a sound good approach may affect Query Performance and Optimization, Storage Efficiency, scalability and Maintenance, Data Integrity. Recommended

Re: Long running query causing XID limit breach

2024-05-22 Thread Muhammad Salahuddin Manzoor
Greetings, In high-transaction environments like yours, it may be necessary to supplement this with manual vacuuming. Few Recommendations Monitor Long-Running Queries try to optimize. Optimize Autovacuum. Partitioning. Adopt Vacuum Strategy after peak hours. *Salahuddin (살라후딘**)* On Thu,