Today I spent the day at the ex-workplace, as a consultant – they have a 5GB postgresql database, and needed some optimizations, not to overload the machine. The iron itself isn’t something great, a dual machine with 1G ram, and works pretty well under the load (about 30 queries per second). The problem was solved easily – I pulled all the slow queries from the log, sorted then by time of execution, and with some EXPLAINs, indexes and thinking the heaviest things were fixed, tomorrow I’ll repeat the procedure with everything else that pops out. Mostly an exercise in query optimization, he database itself had nothing to tune, worked like charm :)
\n(I can’t deny it, I love postgresql :) )<\/p>\n
In the evening I got out for a walk with Lora and Fozzie (e.g. we looked for a while for a place to sit, in the end ate at “Trops”, and sat in a really nice nearby coffee shop). I gave Lora “No logo”, let’s see what will be her opinion on the book.<\/p>\n","protected":false},"excerpt":{"rendered":"
Today I spent the day at the ex-workplace, as a consultant – they have a 5GB postgresql database, and needed some optimizations, not to overload the machine. The iron itself isn’t something great, a dual machine with 1G ram, and works pretty well under the load (about 30 queries per second). The problem was solved […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-965","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=965"}],"version-history":[{"count":0,"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/965\/revisions"}],"wp:attachment":[{"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vasil.ludost.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}