Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres diskspace usage, indexing on TPH #1650

Open
oskogstad opened this issue Jan 6, 2025 · 1 comment
Open

Postgres diskspace usage, indexing on TPH #1650

oskogstad opened this issue Jan 6, 2025 · 1 comment
Labels
needs consideration Requires additional consideration

Comments

@oskogstad
Copy link
Collaborator

No description provided.

@elsand
Copy link
Member

elsand commented Jan 8, 2025

Refinement:

See comment on #1497.

Actors do also carry alot of duplication, as the name of the actor is resolved immediately and stored in full. A better approach would be to have a internal "ActorName" table, which is referred to by id from each actor object within a dialog aggregate.

Name resolution should still happen immediately, but instead of storing to the actor-entity directly, a lookup for that identifier/name pair is performed, and if it matches, a reference to that actorname is stored. If no match is found (either the actor is previously unseen, or has changed name), a new entry is stored and referred to by the actor-object. This will effectively normalize the name property of the actor entity, while maintaining immutability with regards to name changing etc.

Edit: added a separate issue for this: #1669

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
needs consideration Requires additional consideration
Projects
Status: Backlog
Development

No branches or pull requests

2 participants