Psycopg 2.8.6 on Centos or Ubuntu very slow #1595
Replies: 2 comments
-
|
Most likely it's not a problem with psycopg.
|
Beta Was this translation helpful? Give feedback.
0 replies
-
|
This came from the extremely fragmented vidéo ID index of over 90. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
We run a small Python3 script making a first select to get all the videos whose loop another SELECT reads the information about these videos. This script reads 3 videos per second. The query on the database runs in 2 seconds to read 977880 records.
About 15 days ago, we do about 1,000 reads per second with this same script. Why this performance degradation?
titi.txt
Beta Was this translation helpful? Give feedback.
All reactions