I'm getting dozens of unwanted indexed pages in Wordpress that are actually media files URLs like this one: /wp-content/uploads/2024/11/Ellipse-78 I added a rule in my robots.txt, but I'm not sure it's okay because I do want crawlers to track my…
I have a gigantic indexed (104 million row) table of docs, pages and words: CREATE TABLE my_table ( doc_id integer, page_id integer, word_id integer ); CREATE INDEX my_table_word ON my_table (word_id); CREATE INDEX my_table_doc ON my_table (doc_id); CREATE INDEX my_table_page…
I have a collection estates with a unique index on the name field, created thus: db.estates.createIndex ({ "name": 1 }, { unique: true }) This works - attempts to insert a duplicate name cause an error. I try to create…
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…