I have AWS RDS PostgreSQL as a database. I have a table for storing childbirth_data data with currently 5M records and another for storing message to child stats (not the actual messages) with 30M records. Monthly around 0.3M person records…
I have a table (under RDS Postgres v. 15.4 instance db.m7g.large): CREATE TABLE MyTable ( content_id integer, part integer, vector "char"[] ); There is a B-Tree index on content_id. My data consists of 100M rows. There are 1M (0 ..…
I have a vehicle table with many rows. Every vehicle is stored with a name, and then additional characterizing attributes. Let's say name PRIMARY KEY attr_1 attr_2 attr_3 attr_4 etc... The user can search via a web form by name…
ASP.NET MS SQL table: tblPets ID (123456789) AnimalType (Dog, Cat, Goldfish...) AnimalName (Rudolf, Ben, Harold...) CountryCode (US, AU..) StateCode (CA, NY...) CityCode (AK, LA...) IsMammal (True, False) IsFish (True, False) HasFur (True, False) Color (Black, Brown, Orange...) WeightKG (34, 57,…
I have this table that has a 'unique together' index: CREATE TABLE IF NOT EXISTS entity_properties ( entity_id INTEGER NOT NULL REFERENCES entities, property_id UUID NOT NULL REFERENCES properties, value VARCHAR, value_label VARCHAR, UNIQUE (entity_id, property_id) ); I want to…
10 million rows. MySQL server V. 5.7 Two indexes called "tagline" and "experience". This statement takes < 1 second: SELECT count(*) FROM pa WHERE MATCH(tagline) AGAINST('"developer"' IN BOOLEAN MODE); This statement also takes < 1 second: SELECT count(*) FROM pa…
I have a database with users collection which contains a verified field in its schema. I want users that have not been verified 5min after account creation to be deleted. How can I do this? I am already familiar with…
I want to implement efficient pagination in Postgresql (14.5): give me a few rows associated with some a, that come immediately after some b. Unfortunately Index Cond disappears from under the Index Only Scan as soon as I try to…