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…
I have the following JSON data : $ cat toto.json { "method": "GET", "path": "/users/sign_in", "status": 500, "exception.class": "NoMethodError", "exception.message": "undefined method `user_azure_activedirectory_v2_omniauth_authorize_path' for #<ActionDispatch::Routing::RoutesProxy:0x00007d6fe7cfd0d0 @scope=#<SessionsController:0x00000000186758>, @routes=#<ActionDispatch::Routing::RouteSet:0x00007d701b857b28>, @helpers=#<Module:0x00007d701b6f38b8>, @script_namer=nil>" } { "method": "GET", "path": "/users/sign_in", "status": 500, "exception.class": "NoMethodError", "exception.message":…
I need some help to optimize my filtering/pagination system under Symfony/PostgreSQL. I have a table "link" with ~5M rows and this query used for the pagination system with https://github.com/KnpLabs/KnpPaginatorBundle. SELECT * FROM link l0_ WHERE l0_.team_id = 21 AND l0_.folder_id…
I have a very big table with a column that has mostly null values. I query this table a lot with x_column is not null condition. I wonder how I should index it and what is the best way to…