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
_______________________________________________
infrastructure mailing list
[email protected]
https://admin.fedoraproject.org/mailman/listinfo/infrastructure

Reply via email to