DB performance of frequently updated table

[Miroslav Suchý]

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