I'm trying to figure out what is causing the Aurora RDS Postgres database to deteriorate in terms of performance over time. I have a quite big table in a multi
I have a database of orders and each order has a time_slot (of type TIME). select id, time_slot from orders limit 5; 10 | 13:00:00 11 | 12:00:00 13 | 11:00:
If you have a local database, Staging/UAT database, Production database 1)Say 10 developers have the database script to generate the database (I'm using liquiba
I have a table which contains the locations, the actors and activities complete by actors. Please see the example on the below image. enter image description he
I followed this guide in order to upgrade the plan for postgres: https://devcenter.heroku.com/articles/updating-heroku-postgres-databases#updating-with-addons-u
create index if not exists department_index on department using btree (department_id); How can I create a Liquibase changeset for the above Postgresql? I h
I am using PostgreSQL 9.4 and I have a requirement to have an 'addresses' array which contains closed JSON objects for different types of address (residential a
Am new to Postgres. Anyone can tell how to have it work? What I want to do is to write Pandas datataframe to PostgreSQL database. I have already created a datab
I'm trying to load a large dataset (25 GB) into a Postgres table. The command below works, but it takes 2.5 hours and fully utilizes 3-4 cores on the machine th
I can in Prisma create columns without data, without time? my model at the moment: model modelName { id Int @id @default(autoincrement()) creat
Environment: Postgresql 13.x (dockerized) I was trying to test the DR setup for PostgreSQL nodes. pg_basebackup and wal_files archive was taken from the standby
Given a year and a quarter, a procedure should INSERT values into table tb_quarter, which is empty and have this structure: CREATE TABLE erp.tb_quarter (
PostgreSQL 13 The goal is to rename all src keys in the photos array to image. I have a table plans which has a column json with a simplified structure similar
I use PostgreSQL 13.3 I'm trying to think how I can make include/exclude in query at the same time I have include_system_ids [1,5] and exclude_system_ids [3] Th
I have a table which looks like this: ID money_earned days_since_start 1 1000 1 1 2000 2 1 3000 4 1 2000 5 2 1000 1 2 100 3 I want that rows, without a days_s
I want to import a large csv file without creating table before for that csv file into postgresql. While searching on stackoverflow, one of th
I've had a few project which is using this same database and entities. How to reuse entities across all of this projects? I don't want to copy all *.entity.ts f
I want to create a python function that takes a start date and end date as arguments. I want the dates passed to the function to be the start date and end date
I am trying to define two roles in Hasura: role_1: In my_table, can update: column_A and column_B role_2: In my_table, can update: column_C I want an end user t
How to configure a PSQL v11.4 user that is not the superuser and does not own the database. This user should have full access to create SQL objects and drop the