benawad / benawad/fullstack-graphql-airbnb-clone

pg schema has no index

Open
#17 1 comment 1 reaction 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.