I have a table which is used as a job queue. New rows are continuously being inserted in the table and the fetched rows are updated. There are JOINs in the query and Postgres uses Nested Loop join for it.…
I want to have an array of distinct integer values across my postgres table as the return value of a stored function. The stored function currently looks like this create or replace function get_unique_entries(id int) returns table ("entry_id" int) language…
We are building lightweight text search on top of our data at Postgres with GIN indexes. When the matched data is small, it works, really fast. However, if we search common terms, due to many matches, the performance of it…
This works perfectly and the database is connected, no problems. But I do not want to hardcode my values in the function and hence am using an env file. But using os.getenv doesn't connect to the database. package main import…
So I'm transferring domain classes (a lot) to the postgres with EF6. Classes can have value type properties, like int and float, and are being transferred to postgres as NOT NULL. I can't make my domain classes properties nullable, as…
Within my db I have table prediction_fsd with about 5 million entries. The site table contains approx 3 million entries. I need to execute queries that look like SELECT prediction_fsd.id AS prediction_fsd_id, prediction_fsd.site_id AS prediction_fsd_site_id, prediction_fsd.html_hash AS prediction_fsd_html_hash, prediction_fsd.prediction AS…
I have a postgresql dump of some seed database. This dump was created few months ago so all data is there are about the past. It is not very convenient to develop on the past data because I have to…
I have a Dropwizard + Jdbi + Postgres 12 setup. I want to run following query with a SQL/Json Path Expression on a complex/nested JsonB column: try (Handle handle = jdbi.open()) { return handle.createQuery( "select data from company where" +…
I have a Postgres database on Heroku and I want to have that database hosted on ElephantSQL, but I cannot for the life of me find how to do it. I have a DUMP file downloaded from the Heroku Postgres…
Idea: need to run a daily cron job that upsert+delete a bunch of data to/from a target table. The data is in a txt file; it contains the newest version of the data that the target table should eventually have.…