Question : What I have is a very simple database that stores paths, extensions and names of files from UNC […]
Tag: gist-index
PostgreSQL, integer arrays, index for equality
Question : I have a huge list of integer arrays (300,000,000 records) stored in Postgres 9.2 DB. I want to […]
Postgres LIKE query using a GiST index is just as slow as a full scan
Question : What I have is a very simple database that stores paths, extensions and names of files from UNC […]
slow index creation with gist and gist__int_ops
Question : I am seeing performance issues with frequently updated / inserts table, and one of my hypothesis is the […]
PostgreSQL – Datetime ranges overlap
Question : I have a table with datetime fields start and end. And I have a list of (start, end) […]
PostgreSQL planner choosing btree or gist index for few result rows
Question : I have a scenario where a search on a range with the same value on both sides is […]
slow index creation with gist and gist__int_ops
Question : I am seeing performance issues with frequently updated / inserts table, and one of my hypothesis is the […]
How can I speed-up my query on geo-location processes
Question : I have a table that contains 10,301,390 GPS records, cities, countries and IP address blocks. I have user’s […]
Does spgist extension in PostgreSQL 9.2.3 support float or int array?
Question : SP-GiST is an abbreviation for space-partitioned GiST in PostgreSQL 9.2.3. It can be used to find the similar […]
Queries using GIN index on f_unaccent() seem slow?
Question : I have almost 20M rows in one table that contains product, including their names. I wish to search […]
- 1
- 2