Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: postgresql-13

Update a column to same value for all rows in a group of the group by

By adminPosted on January 31, 2023

Question : I have the following table: name key uuid na1 k1 NULL na2 k2 NULL na3 k1 NULL If […]

postgresql Recursive Update resulting in Sequential Scan

By adminPosted on January 30, 2023

Question : I have a table with a self-referential foreign key, and I would like to update a given parent, […]

UPSERT with UPDATE on variable column gives error “command cannot affect row a second time”

By adminPosted on January 20, 2023

Question : Hey I’m trying to insert or update(if the constraints are duplicated) based on a query result, these are […]

Run calculation not working in sub query, “does not exist”

By adminPosted on December 10, 2022

Question : PostgreSQL 13.2 (Debian 13.2-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit I have a query that […]

Selecting related data without selecting foreign key from subquery [closed]

By adminPosted on December 2, 2022

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

How to integrate Postgres advisory lock functions into SELECT and UPDATE?

By adminPosted on October 12, 2022

Question : Using Postgres 13 in a Node.js application, I have a simple task to do: SELECT a row (identified […]

RECURSIVE CTE does not use an INDEX. (Disabling seqscan forces it using an index however and it is faster)

By adminPosted on September 9, 2022

Question : Suppose the following relations: match(match_id) event(match_id, seq, gt, …) There are the following indexes: match(match_id) event(match_id, seq) Further […]

Why PG 13 does not allow deferring statement trigger constraints?

By adminPosted on June 18, 2022

Question : I noticed in PG 13 docs that only row constraint triggers can be deferrable. Why not statement constraint […]

Recovery with Postgresql logical replication

By adminPosted on June 4, 2022

Question : I’m using Postgresql 13 on Debian 10.6 and learning about logical replication. I’ve set up logical replication with […]

How to conditionally create JSON array in postgres with group by clause?

By adminPosted on May 19, 2022

Question : I am using Postgresql 13.0 and have a table category as follows: cat_id | cat_name | piece | […]

  • 1
  • 2
  • 3

Recent Posts

  • Can this query be simplified? Calculate cumulative length of segments and collapse coordinates into linestring
  • Explanation for second Compute Scalar
  • Why is this datetime index not being used?
  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding