Re: UPDATE with multiple WHERE conditions

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 w

Bugs details.

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 release

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

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 ogr_f

Re: Memory issues with PostgreSQL 15

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 memory

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

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 SE-Post

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

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

lion > XID per hour= 2billion 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

Re: Long running query causing XID limit breach

gt; On 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 Recommendatio

Re: Json table/column design question

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 approach

Re: Long running query causing XID limit breach

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, 23