I have a DB in postgres with two tables, 'responses' and 'variables', like this: responses respondent_id variable_name response 01 name susan 01 age 42 02 name bob 02 age 13 variables variable_name type name text age integer Note: The data…
good morning, I'm working on a datalake that retrieves data from sqlserver, transforms it with dbt and then inserts it into postgresql. The format of my source data has changed (the software editor has made changes in sqlserver) and I…
I have an asp.net (version 8) webapi project that I have set up to work with docker. I have the container that runs my API and a volume where I put my database. It works and I'm able to run…
Problem The following query takes 42 seconds when most of the data in not cached: EXPLAIN (ANALYZE, BUFFERS) select count(*) from packages where company_id = 178381; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------- Aggregate (cost=395914.63..395914.63 rows=1 width=8) (actual time=42411.940..42411.942 rows=1 loops=1) Buffers: shared hit=21775…
Stupid question, I know, but I can't find the download link https://www.postgresql.org/download/ https://www.enterprisedb.com/downloads/postgres-postgresql-downloads the first page takes you to the second page, and then the second page takes you to first page back again Could anybody provide the right link…
I have the following docker-compose file and when I ran docker-compose up -d --build, I got a message which indicated success. The logs did not have any exception printed. [+] Running 2/2 ✔ Container fastapi-tdd-docker-web-db-1 Running 0.0s ✔ Container fastapi-tdd-docker-web-1…
I want to join two tables to get the output as shown in Table4. Below are the details: Table1: SalesData Date PlatformId UnitsSold Revenue ChannelId 2024-07-01 ABCD1 12 1200 1 2024-07-02 ABCD1 11 1000 1 2024-07-01 ABCD2 4 1200 2…
I have a PostgreSQL table named users which contains between 20 to 30 million records. The table has the following columns: id, tenant_id, name, company, location, and description. I need to perform generic search queries on this table with various…
Can anyone help me please with this? what I run: docker run --name pgres --rm -e POSTGRES_USER=uzer -e POSTGRES_PASSWORD=1234 -e POSTGRES_DB=sample_db -p 5432:5432 postgres:14.1 but I cannot connect to that: even Nothing happens in the log: waiting for server to…
So I have 2 tables - Videos and Watches (with datetime). I want to order the videos by the last time watched by a given user, with the never before watched videos coming first and the rest being sorted by…