fix: library pagination to 10k to avoid too many postgres query params

fix: library pagination to 10k to avoid too many postgres query params #6691