devthejo
16b7e7d6aa
All checks were successful
/ build (map[dockerfile:./services/hasura/Dockerfile name:hasura]) (push) Successful in 47s
/ build (map[dockerfile:./services/web/Dockerfile name:web]) (push) Successful in 1m47s
/ build (map[dockerfile:./services/watchers/Dockerfile name:watchers]) (push) Successful in 2m37s
/ build (map[dockerfile:./services/files/Dockerfile name:files]) (push) Successful in 2m52s
/ build (map[dockerfile:./services/api/Dockerfile name:api]) (push) Successful in 3m2s
/ build (map[dockerfile:./services/app/Dockerfile name:app]) (push) Successful in 31s
/ build (map[dockerfile:./services/tasks/Dockerfile name:tasks]) (push) Successful in 2m44s
/ deploy (push) Successful in 48s
1 KiB
1 KiB
| Index Type | Best For | Supported Operations | Comments |
|---|---|---|---|
| B-Tree | Equality and range queries | =, <, <=, >, >= | Default index type |
| Hash | Equality queries | = | Less commonly used, fewer operations supported |
| GIN | Full-text search, arrays, JSONB | Various | Optimized for composite data types |
| GiST | Geometric data, complex searches | Various | Versatile, supports many types of searches |
| SP-GiST | Dynamic, partitioned data | Various | Suitable for k-nearest neighbors, quadtrees |
| BRIN | Large, naturally clustered data | Various | Efficient for large tables, time-series data |