I am running MySql v8.0 with InnoDB. I have a simple transaction that has a SELECT (not a SELECT ... FOR UPDATE) followed by an INSERT. I'm getting frequent deadlocks when many DB inserts are happening simultaneously. All inserts use…
I have a query like: SELECT DISTINCT ON (services.group_id) services.service_id, ... FROM services WHERE services.group_id IN ('67240181b97477f054f9b1bc', '67240181b97477f054f9b1be') I have an index on group_id. Why does Postgres need to do an extra heap scan? I just want any 1st match…
I have a table structure analogous to this towns (id, name, region_id) regions (id, name, country_id) countries (id, name) I need to enforce the uniqueness of town name within the country. In a given country, if we put together all…
I have a table: create table accounts_service.operation_history ( history_id bigint generated always as identity primary key, operation_id varchar(36) not null unique, operation_type varchar(30) not null, operation_time timestamp with time zone default now() not null, from_phone varchar(20), user_id varchar(21), -- and…
I'm revisiting an old question from 16 years ago about PostgreSQL HASH indexes vs B-TREEs. At the time, it seemed like HASH indexes were far less efficient than B-TREEs in terms of both space and time and the consensus was…
I have a table that contains ~ 100.000.000 records. In this table, there's a varchar(30) column that contains the license plates of cars. I'm joining this table with another table that contains the same amount of records. I need to…
Some of my collegues claimed: Postgres use a simple index little bit less than a converted to text one... CREATE INDEX simple_index ON my_table(my_varchar); CREATE INDEX text_index ON my_table((my_varchar::text)); And I wonder that the analyze always convert it to text…
Through the web interface of ai.azure.com I created all the necessary services such as azure ai studio with project, storage account, open AI, AI search, etc. And I connected all the services to a private endpoint. The problem arose only…
My website uses two pages to generate nearly all the content. I have fixed the complaints Google had with browser URL rewrites and canonical references only to have it choke on redirect. I use htaccess to convert the desired public-facing…
I have found usages of creating indexes with WHERE and INCLUDE operators at some project migrations. The index creation looks like: CREATE INDEX CONCURRENTLY IF NOT EXISTS some_index ON some_table USING btree(some_column) INCLUDE (status) WHERE status = 'Done'; And the…