I have a Postgres table with 350M records. I have 3x indexes on it: historical_offers(recovery_date, uprn) historical_offers(recovery_date, account_id) historical_offers(recovery_date, individual_id) If I run a query for a date older than 24hrs it's fast. But if I run it for today…
I have a photos table, a tags table, and a bridge table called photos_tags. Imagine there's a photo which has been tagged with dog, cat, and bird. This means that there'll be 1 record in photos, 1 record in tags,…
I'm using SQL and I have some dummy car dealership data that for a given dealership tells me whether a particular make is currently being sold there, and if not, when the last time that make was available at that…
I am learning Springboot and wanted to make an application that lets me use postgres to make simple APIs. I have been trying to establish the connection to the JDBC to be able to create a table, however it will…
I currently have this SQL: select ROW_NUMBER()OVER(order by priority DESC NULLS LAST , created_at DESC) as index , id , title , ago(created_at) , priority , user_id from post order by priority DESC NULLS LAST , created_at DESC; As you…
I'm using PostgreSQL with a .NET project, and I'm facing an issue executing a stored procedure through Dapper when using dynamic parameters to pass a DATE parameter. The stored procedure is defined as follows: CREATE OR REPLACE PROCEDURE simplemenuproc( appcode…
I have two options and not know which is the best: 1 - After coping Django files, delete migration files, so after makemigrations and migrate tables will be created. And after that import dumped database (only data). or 2 -…
I have an application that utilizes Advantage Database Server, and I want to migrate it to PostgreSQL. To remove a table from the database dictionary, I use the following SQL query: DROP TABLE table_name FROM DATABASE NO_DELETE; The NO_DELETE keyword…
Does anyone have any idea why I get the error? I use t for which I receive, old to compare and up are the new or modified data equally to compare with the old ones. Why do I keep getting…
I am building a location-based service in Go and using spatial data (latitude and longitude) to group units. I need to group these units dynamically based on the user's zoom level and geographical proximity. Here is the problem I’m facing:…