Question : I started an hours-long Postgres query in my psql shell. Then, I got disconnected from the network and […]
Category: Postgresql
How do I return all column values for the recently inserted row/rows?
Question : I have these two tables in a PostgreSQL 12 database: CREATE TABLE public.test ( entity_id uuid PRIMARY KEY […]
Strange performance of a top-N query with Postgres
Question : I have a table transfer_event from which I need to find the latest n entries for a set […]
Refresh Materialized View impact on the DB
Question : Hi we are running an PostgreSQL 9.6 database in Amazon RDS under a m4.large(2cpu 8gb) and a provisioned […]
Optimizing a query which runs through all hours in a day
Question : I need help optimizing a query. I’m using PostgreSQL 9.3.4 currently but can upgrade to 9.4 if needed. […]
Add a suffix to duplicates on PostgreSQL
Question : Not sure about the term “undouble”, I am just trying to add a unique index on a column […]
pg_dump: Write failed: Connection reset by peer
Question : we are trying to move all database data to other location. we chose to perform pg_dump and we […]
Add function parameter to SQL query WHERE clause
Question : I have a web application in java and it uses a query. I don’t want to write the […]
Postgres consuming a lot of cpu [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Need a log based replication / CDC solution to publish postgres to oracle subscribers
Question : We have a moderately large postgres 9.1 db that is currently 3TB and will likely grow much larger […]