stac-utils / stac-utils/pgstac
Allow building/updating queryable indexes without locking the table.
Nobody has claimed this yet.
- Dominant language
- PLpgSQL
- Stars
- 223
- Forks
- 57
- PR merge metrics
- No merged PRs in 30d
Description
Building or changing an index normally locks the table until it's done, which isn't great on tables that already have real data in them. Postgres has a way to build indexes without locking (CONCURRENTLY) but this comes with significant limitations. But still, it would be great if there would be a way to update the indexes without locking their tables.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The issue names no files or tests. Start by locating pgstac's index creation and update definitions, then review PostgreSQL's CONCURRENTLY restrictions; done means providing a tested path for changing queryable indexes without locking their tables while accounting for those limitations.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, sql
- Domain
- databases, performance
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100