Dne 2.7.2015 v 10:49 Michael Šimáček napsal(a):
We've been facing some DB performance issues in Koschei
production machine recently. Our central table (package) has
only ~10000 rows but sequential scan of the table was taking unreasonably long (~4s).
Other tables that are orders of
magnitude bigger were faster to query. I was investigating the problem and it turned out
that the table occupied very
large amount of disk space:
So why are you not using indexes?
--
Miroslav Suchy, RHCA
Red Hat, Senior Software Engineer, #brno, #devexp, #fedora-buildsys