Re: DB performance of frequently updated table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
infrastructure@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/infrastructure




[Index of Archives]     [Fedora Development]     [Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [KDE Users]

  Powered by Linux