benawad / benawad/fullstack-graphql-airbnb-clone
pg schema has no index
- Dominant language
- TypeScript
- Stars
- 1.7k
- Forks
- 444
- PR merge metrics
- No merged PRs in 30d
Description
I wonder what the perf will be if there are actually indexes
foreign keys are not indexed by default for pg https://github.com/benawad/fullstack-graphql-airbnb-clone/blob/master/packages/server/src/migration/1531437838812-ListingUser.ts#L7
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with packages/server/src/migration/1531437838812-ListingUser.ts at the referenced foreign-key definition. Check how the PostgreSQL schema represents indexes and determine what performance comparison is expected. Done means the indexing question is resolved with the relevant schema change or measured result.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, typescript
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100