I have a table tbl in Postgres with 50 million rows. The tbl has an index on column_1 and there are a lot of queries to this table like select * from tbl where column_1 = 'value' Each query returns…
I have a simple MySQL table which consists of a primary key ID field, a timestamp (integer) field, and a foreign key ID field (device_id). There are indexes on each of these columns: mysql> show indexes from device_heartbeats; +-------------------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ |…
I have a site that gets a lot of traffic this time of year (around 50,000 users a day). The traffic goes up every year and all the sites on my server are starting to crash more, apparently because of…
Trying to create a conditional unique index in postgresql but unable to do so and getting this error Query 1 ERROR: ERROR: cannot use subquery in index predicate LINE 3: WHERE ( ^ this is how my query looks like…
I've created a column of usernames but the ids for each row is linked to another table. If a user is deleted, I'd like to change the username to 'Deleted'. So I'd like to allow for unique values except for…
I have faced this scenario in one of my interview. There will one table with millions of records and the table is going to have only two columns id which is primary key and time_stamp which is of type date…
I want to setup multi-level index in my firebase realtime database. My database structure looks like this, in which the root key name is jobOpenings which contains child of job opening id (for instance particularJobId) which is going to contain…
My partial index in PostgreSQL 14: CREATE INDEX idx_invoice_account_id ON invoice (account_id) WHERE NOT "is_deleted"; Every invoice row starts with is_deleted = false before 50% of them get deleted (is_deleted = true). Does PostgreSQL remove it from index? If not,…
Hi i was reading postgres indexes, trying find a solution to make gin operator work with like on array. Let me explain. I have a need to find a range of unique keys. This is not that simple, because i…
i'm having a little problem, trying to optimaze quering data from a unstructured json field. By unstructured i mean, each json field is unique on each row. by using this query, i want to collect all the keys which are…