Hi @asmecher
Is that query. But it’s insane.
ojs3=# select count(*) from submission_files;
count
179843
(1 row)
Time: 36.331 ms
ojs3=# select count(*) from articles_migration;
count
92639
(1 row)
Time: 30.285 ms
ojs3=# select count(*) FROM submission_files sf, articles_migration am WHERE am.submission_file_id=sf.file_id;
count
36354
(1 row)
Time: 78.130 ms
Is there some explanation? Is there other way to upgrade?
Regards,
Tarcisio Pereira.