All Questions
Tagged with postgresql-9.2 gist-index
4 questions
2
votes
1
answer
532
views
How to determine if postgres database contains GiST indexes and what type?
Is there a way to easily check if a PostgreSQL database has any GiST indexes and of what type they are?
- 309
15
votes
1
answer
9k
views
Order by distance
If I have a query returning nearby cafes:
SELECT * FROM cafes c WHERE (
ST_DWithin(
ST_GeographyFromText(
'SRID=4326;POINT(' || c.longitude || ' ' || c.latitude || ')'
),
...
12
votes
1
answer
7k
views
2 B-tree indices OR 1 GiST index on tsrange -- which will perform better?
I have a table which is storing reservation data using the columns starts_at & ends_at Whenever I'm querying the table to find overlapping reservations, I have an option of using one of the ...
- 333
2
votes
1
answer
499
views
Does spgist extension in PostgreSQL 9.2.3 support float or int array?
SP-GiST is an abbreviation for space-partitioned GiST in PostgreSQL 9.2.3. It can be used to find the similar tuple by creating the sp-gist index on the column.
e.g:
create index pt_spgist_idx on ...
- 121