{"version":"1.0","provider_name":"Rainbow Dash Network","provider_url":"http:\/\/rainbowdash.net\/","type":"link","title":"Toksyuryel (toksyuryel)'s status on Wednesday, 09-May-12 08:50:01 UTC","author_name":"Toksyuryel (toksyuryel)","author_url":"http:\/\/rainbowdash.net\/toksyuryel","url":"http:\/\/rainbowdash.net\/notice\/1352720","html":"@<span class=\"vcard\"><a href=\"http:\/\/rainbowdash.net\/user\/1948\" class=\"url\" title=\"Cerulean Spark\"><span class=\"fn nickname\">ceruleanspark<\/span><\/a><\/span> There'll always be room for improvements^^ you'd have to dig into the Python and SQL code though. PostgreSQL helpfully provides the EXPLAIN and EXPLAIN ANALYZE commands for performance fetishists to go nuts optimizing queries with, and it's even possible to write trigger functions in C."}