We've run into a strange issue with Postgres, initially unearthed as we prepare to upgrade from 10.21 to 11+. What we'd initially thought was a performance regression in newer versions of Postgres appears, in fact, to be a performance regression…
I have the below query using execute to add data using execute, what would be a executemany version of this code? import psycopg2 import os from dotenv import load_dotenv load_dotenv() urlstocopy = return_list_urls2(1300000) def main(): # fake values conn_string =…
So I'm trying to union two queries and then order by a column. However, whenever I try and run the query it gives an error that doesn't make sense to me. Example data CREATE TABLE test ( Company_code VARCHAR(120) NOT…
I make a backup with the command docker exec -t arcane-aio pg_dump arcane-aio -c -U admin > arcane_aio_db.sql I restore the backup with the command cat arcane_aio_db.sql | docker exec -i arcane-aio psql -U admin -d arcane-aio All is good,…
Suppose the following data: user_id timestamp value -------------------------- 2983 2022-01-01 12:01 100 2983 2022-01-01 12:04 106 2983 2022-01-01 12:06 101 2983 2022-01-01 12:10 110 2983 2022-01-01 12:11 112 2983 2022-01-01 12:13 115 2983 2022-01-01 12:15 102 I'm trying to perform…
We have a k8s cluster and postgres pods are running in it. Our backend services connect to postgres K8s service. I am trying to introduce PgBouncer as proxy when connecting to postgres pods. Postgres has ssl mode enabled and we…
I have already created table .I want to add one more string column into it. ALTER TABLE test."persons" ADD COLUMN RightName VARCHAR(150); Column get added in table with name rightname. Why this is so,why not RightName?Any thing I missed. Do…
I have a table where we have barcodes and order numbers, so, I am trying to find all the barcodes that are being assigned to multiple orders. Example table barcode ord_no 1233 1 1234 2 1233 3 1235 4 1236…
I have in my postgres database, the following table: CREATE TABLE trips(id int, lat_init double precision, lon_init double precision, lat_end double precision, lon_end double precision); INSERT INTO trips(id, lat_init, lon_init, lat_end, lon_end) VALUES (1,53.348060,-1.504068,53.360690,-1.457364), (2,53.427651,-1.355329,53.380441,-1.536918), (3,53.365660,-1.497837,53.363838,-1.388023), (4,53.380349,-1.460028,53.429298,-1.359443), (5,53.345526,-1.449195,53.407839,-1.501819); So that…
Say, there is a table A, with columns a and b, both are int type with unique index. I want to select from A where if there a tuple whose a equal to 100, then return this tuple otherwise, return…