gist-index Questions

Postgresql – Slow query with like on Postgres 14.6

October 22, 2024
Mario Agati
2 Answers

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…

VIEW QUESTION

Postgresql – How to make a composite index in Postgres including a POINT?

October 31, 2023
fadedbee
2 Answers

With this table: CREATE TABLE bins ( id SERIAL PRIMARY KEY, start TIMESTAMP NOT NULL, bits BIT(16) NOT NULL, topleft POINT, -- (x,y) in web mercator projection count INTEGER ); CREATE INDEX ON bins USING gist(topleft); How can I create…

VIEW QUESTION