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

ANNIS locks too many tables if querying multiple corpora #357

Closed
thomaskrause opened this issue Sep 24, 2014 · 0 comments
Closed

ANNIS locks too many tables if querying multiple corpora #357

thomaskrause opened this issue Sep 24, 2014 · 0 comments
Assignees
Labels
Milestone

Comments

@thomaskrause
Copy link
Member

When querying more than one corpus ANNIS will use the parent "facts" table in it's FROM clauses. This will acquire a lock on all child tables, even if they are excluded by the conditions. If you have more corpora imported than the value of the max_locks_per_transaction PostgreSQL parameter there will be an error. It is also bad for the statistics since PostgreSQL will use the overall statistics of all fact tables combined.

We should fix it in a way that only the fact-child tables that are really needed are queried.

@thomaskrause thomaskrause self-assigned this Sep 24, 2014
@thomaskrause thomaskrause added this to the 3.2.0 milestone Sep 24, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant