Where can I find statistics for specific table column scans? I have a very large table (near 10^9 rows) which has a few indexes however not on all fields. The non-indexed fields are mostly foreign ...

I have two tables: my_table1 and my_table2. a_column in my_table2 should always match the corresponding value in my_table1. However, the tricky part is that rows in my_table2 may be inserted before or ...

I am struggling with restoring a dump for several reasons and I am not even sure I am taking the right direction. Basically my issue seems to depends on my understanding of role and priviledges in ...

I have been given the task of importing data from a 3rd party. Not knowing what the data would look like, I imported it into a JSON field in a PostgreSQL table. Now to make things easier, I want to ...

I have a table with rows with a JSONB in this form (YAML here for readability): { foo: 500, bar: 12 } { foo: 500, bar: 18, zoo: 5 } ... There can be arbitrary keys in the objects, but always ...

I'm working in an environment where I expect several containers to be running queries to "claim" a database row. The multiple containers are for redundancy, but I only ever want one ...

Looking at the PostgreSQL/15/data directory on a Windows machine, I found the postgresql.conf file. In the file, it has #dynamic_library_path = '$libdir' What determines what $libdir is set to and how ...

I tried following the instructions here: https://github.com/pgvector/pgvector#windows The error message that I am getting is this: ERROR: extension "vector" has no installation script nor ...

I accidentally ran and committed drop schema information_schema cascade on postgres 15.4 as a DBA. How to recreate the said schema?

We have a postgres trigger that is set to run when eastings and northings values are inserted or updated on a row. The trigger function use postgis to transform the eastings and northings, which are ...

My system is running instances of postgres managed using CloudNativePG; there's a primary and a couple of replicas. When I run a query like this update <table> set <boolean-column> = NOT &...

We're running a Rails application on Heroku, with Postgres 15.7 (on the plan Heroku Postgres standard-2) Before upgrading to Postgres 15.7, we were on 12.x with Heroku Postgres standard-0. We have ...

The database was under sustained high load of inserts into a specific table for several hours. At some point, all inserts to that table (and some updates I tried to another table) fail with the ...

I recently installed the PostgreSQL extension temporal_tables (v1.2.2) on our PostgreSQL database (version 15.2 installed on Microsoft Windows Server 2022 Standard - x64). Note: Installing this ...

I am in the middle of trying to migrate our Postgresql on an EC2 to Postgresql RDS. When I dump one of the DBs and restore it in RDS. One of the users pops up and gives "Error: must be member of ...