X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 235C09DCABE for ; Tue, 14 Mar 2006 08:09:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16894-07 for ; Tue, 14 Mar 2006 08:09:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from techforce.com.br (unknown [64.84.33.124]) by postgresql.org (Postfix) with ESMTP id A779A9DCA29 for ; Tue, 14 Mar 2006 08:09:37 -0400 (AST) Received: from techforce.com.br (techforce.com.br [127.0.0.1]) by techforce.com.br (8.12.11/8.12.11) with ESMTP id k2EC2o0Q022009 for ; Tue, 14 Mar 2006 04:02:50 -0800 From: "andremachado" To: pgsql-performance@postgresql.org Subject: firebird X postgresql 8.1.2 windows, performance comparison Date: Tue, 14 Mar 2006 09:02:49 -0300 Message-Id: <20060314120200.M31128@techforce.com.br> X-Mailer: Open WebMail 2.51 20050228 X-OriginatingIP: 161.148.38.12 (andremachado@techforce.com.br) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=OPENWEBMAIL_ATT_0.492229069673584" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200603/186 X-Sequence-Number: 17623 This is a multi-part message in MIME format. ------=OPENWEBMAIL_ATT_0.492229069673584 Content-Type: text/plain; charset=iso-8859-1 Hello, Attached is a file containing the problematic queries cited yesterday, with "explain", "\di" and "show all" outputs. The first one finished in almost 4 hours. Firebird for windows finished in 1m30s. The second one CRASHED after some hours, without finishing. The error message is at the file too. I will ask my friend to reduce shared_buffers to 16000 as this number gave the best results for his machine. Do you have any suggestion? Regards. Andre Felipe Machado ------=OPENWEBMAIL_ATT_0.492229069673584 Content-Type: application/x-gzip; name="sql_query_problem.txt.tar.gz" Content-Disposition: attachment; filename="sql_query_problem.txt.tar.gz" Content-Transfer-Encoding: base64 H4sICKWvFkQAA0xGZnVsYS50YXIA1F1bc+PGct5n/YI8Tm28sZSz4vKm2yZ7qmiJe6xztNJaku04 lSrUEBiSsEAMhQGkpWsf8h/y5/IP8pTHvKe7Z3AlwAtA2QnLtaRAovtDT0/fpmesHj3rMRLBwpoH cuSJWSv8Er7a7avdabeP+/1X/w6f/+4f/uM/293eyUmv/6qNr067122fvOq0++2jo+5J/6gNvz/q 9o9fsfaOcZS+IhXygLFXfCw8dy4qf6ciX1V/+//2tbc3chx//OHvmfgy97jrMyU8YYfMlpEf7juu Cl0f/rz+2Lq8sK4/HjCu4Ds/5BMxe8suhq3BJ+t2+HF4O7w+vxzQt3w2l2wcyBl8fX41uB2cD27g I2Ou74uA/SqBy/ngYnB3f3uDH5j02T68I4f0jg9AO3fhIHv/9c39wPp4eXc+uAJsREFDjAl/MATj v3N3Dz99vh3eDfCdboV3/K25bDibv3I3Dm5/+PHypxvr8+3N+fDubnBxg5eIBrzjXeYXhob564BN AhnN2WixLDEZOEC97Jt/2mN1Xz/8OLz9hX2+GlzvHf6Rrz32F3zwwWQSiAkPBWP7tlThh24fJvxR 6+i41eoedTudXqvXY4F8Vh86x+zZdcLph9MDfPzDPzN2J4Ow7MZ+H6xI6+TI3Ng/OTo+yd+tX3T/ 38TiPXNEi8+sQIxFIHzb5elvkM/3XE3ZX3GYY2bts17ruN1qnZ6d9tut0946TvpFdM6l77xn+69l FIrgdct1LJs7XIWBZB/Ya1Kp3NUlKvTk4pHd2dxHBfNlyK2xq2zuMX8cQ2y32oCvd3ZyetICSBvh S541ecyjfuusAxLVHwyVIyBTSWOF1E5Ouy2gsz21ldJzhO3xgNu8IL/0+kqqRWkmgwEf8rI86bVT ndoYdVGmJ0enrU4XqNG7pnZ2cny6EbEVwj07anX6jciulLKYzQOheF7E5uLGtEuBd1owyVv9fj+Z 6Rncne7GxFfC58Fj5D4VNMRc3JJDUWEy+ueIvMZ0z45b8ChLD3Vcg2VWh0BkQB3/NdrYNpT7WxIu fyIjFwz8bKEUdyReyj9aI+bF5zntt47BytCbJto7gU/1nqn4NLHmwnv+ESrZ7Xfh0cTERTOgDpJA aDkiiuYOuq5syKFEyH4aWPdw6cq6vB9e311AFPKB7ZvoSUWzfbj8ycKbWvEvD3RUlHzBnqfgiNK/ dYgFZDKs4rBL/7TwRRJFQYyS8C4EPi8SidFLQ8oFOoSj04YfwH/cd7YVCNtGJP/MzjKv2tHS/4FY aY9dCxUKh11Jmahv5/i0dXoEtr572juDMEnr8HFiX7rtThIi4TRbCrJiAp3js1bbxAbdsvmGFEoA dFvtDt4NVNor7k5pXPqO+KJnZKRcf8LGD27GQVupMbbGD2KxxqyCHz4+M8ant8ZKaM7GIeQcAShj GdTv3HDG5+x7Af+sigmMDNqtIwOlt8bV3gp7KuyHGAuQWo5eyqKaFRGWwZqRLoBF0caArRwlLdu8 h4KnyMNflkqlOLd7hEo9yMSvVibuTTQhG9/m9aDXP24dxRp4fFxQ/xLEGVLFwHs5HM8Q+eh68C0Q 2FfRCGy/X7Qx79/70UwErp3NLqLRZ/hpVpwog6XZ2Gv1T+BhWn0TKXRWxT6VUnRDMdOihEfwx4n0 kusF2UFqYAR3tj7WKs4iSDM+sG+0quQes8kD/t6PVvlQVf7/8+D68vw9FkA8B7WSybmA+eZ6gr2e T6wvnpy8a7dN8Uq/ner34clrtg9f6x93+28hTpjMhB+ybq9z8B6gPHHPdSDMmkR4eQ9fcbTxb467 lQe7AuAcjWYgPP5f/yPUHhuqx0jMOPtaccu1nIkqcnDPvTuX9IFdSF/qa/p1z0fAJHWPf6rh4/60 9KGazh6bRyPPtRECnwTRnKO4pCUCMBhzMm8rXl/Zf/uOawv4MAd9ATVVJXRyPJZC4XVcKngs0cly SUze2idYzSWmk6WdMf8bUi+nndLJUjfB9ebAK6gbOjnSGw3pBqQLQ7rWPzYQdpF2LJ4KwlvTXhEy bUy7fCCXqa/Dvi11Gk9EnZlu28qlbCwTumukUZfuev2oR5fetTAcGWyne6vohmCs9R+rJLE53VLv u6V8ExoriYNxdKJVWrEl8ZWB5YbEMzSK5GNbrlU5Vr8qTSwnX0qjhBHJJSMiOXZtFx6r5FEqGeGN RdKkLDHReMZXTv5y0mU0NuVD1yMl82Nfn0+W1HqNKueTobGGfDn6euRd54tl+/Nfk0rr2tfGnpRI SwvyExtNjcstnycqtAXpKtTS8u3Zerz1SCfi9nuQab8Q6X7/6KVIH/d2KRBnCsZoRqaniaxX2xzD yPVBQeRGvJoxCoQt5uhfPUgbyxVyNaPyoKNIPQy4r3ZLPYTZ6sITyg0GYzsHY8inK5I1yVeD95Mh qQ9+dVpDXCJrtAiFsmgF4QW5eK4/3cBo1pJUZCkRuAIrBHWprxhmIv8EDBzuVGbha8gXAzek+8St ELiunlBr6JbGVkRcBApnLF/IKKxJvELiSUi4afK3BXTSkiRA24RBOfEcnSyDbMy5Gf6t9GX+EGI5 fhOprCRPVHKES4PZVU9Q0+bHnrFpxaDEQcIlmAYTStWAPRYh17CpJF2kk2WTJljNFDShs0S8GCiv 5FMvWF4KXWsWz4p0sjy2Ir+CR5b8/lG/tDZbeGdqKp8Z97zi4p/PlyqdVUVRfCkRhliGXol505cj lB2489CV/t76FcU6pdTd3b7ipaHvMe44FkY/IB+LVmuXBCPHmzjMSrkOYMBnPHTBBnoLZKeY4cdC PvKwwK2jI9CSULKPtzefGHiUSAnVAniBPXWfBETjsxkuOC/Tx8bN9b6rEt7PgyvDBBEZNsg4AuXk nst9SBBn4jfpC5W/s6FcLv1QBDCjQ8UG53f3bxn9M8R/8EHvBvfYbTlIYDCEwQgHwQunYNVAqqiI BDHnwr+y43Z9dHD7HQIDHmzGv7izaKbZUwOpLX2HxgqkNfcEODLbc3EZJA9Ko5RP3I6iisSysRDv Qh4YnBleuLynPVgOg8V97i1+Exb6Y2GNuR3KAIi0W90mGK6j2UgE8CQsjEAcICOIM0P11jSWKAZM HIFyUuCUXPgLRGeg4BBzNobwCSWGNALhEZkK6OEUrOlUeo7mfdRuMMpf2SfIDnFs/QaPkMfp8zkp SoFRQ2W8R5LAUnlCzNlIhM9C+NkRD8AKvM1oZx6UecPVRQsegy801cNOI1A/adZIlWmqwH/mep5r QLxlY5BUiqMalOfO3HDnoPgMm7wZf+KuR5Z2JACQAO85n4Ox2whebqrQXOk3gVecK6v0ywztpjPE vOUmCHDENdwGgKtmyHrggG40eQ4ggQkscH0W2NE5n+ScCMzf+sLE27/j9gO2noO/0JwSa53iBd5M MwZoYy9SUzaHb+iuAkS4bqMdz/Fot3q9ddWvrSAaLgAphjeKxhACrAGYTNwih26zEV4GqK0MmbHY 1ND3qjjBM+i8IPrDRvjq9sdNRhghlo5wE4uzwQgjvJUj7En7wVLubxUJ8Vd22jmr76EhSIAsQjFi gArHHFc9aK7AXPq/yiiwSjIKc3fD+DKJo77TnNgokNyxOdhn8LFPmCYhb7AW1FhmjSOfLJ01ko5b 0CWwf/VfX9k5da7FDJhh4EQBRr7nt8PB/ZB9/PH6/P7y5jrGM5euH1qmz0UVCJ42gFMWYuJ2JA6J AM4z7LNJ2GY9PuUSFLanAFUe7lI0bOA2C5bWRsRbonzmgb+UlX5lvWah0pWcgJ0aY4+Sh9RB41Oe qUSnEAMIH1IxDAjGgXiM4DLkZ+EUM42pq9h++mQHCJxCfAvyNFCbklwaOA/uL6/r2pKMeDWnbxXg xroiWWSYgTHnFMvM9a0ZlqnyNtcU8HBmNcZiyDNPPAkPL3GIp0BiCo0oGLMUL8KC5NENqxwV+dKa iIqwMuGmHcii/tESiYmXNCbKKMnw4tChVgJ2NIMpauWOUF+Wl1Yau7BUmCaWArR2FAQoQuq9y+BV cYwK/gHeZ3FOHouV8Ppjd2JRD145w/P37wa6ZKmwgQ5SwUnAZ1y9+6yrUXc/XL07bXXeQQTH38UV qkevhZSzeNE+iwAUcYbbBDTfKKDclloANRjMz3E6iy82CNjN2+jGCe7Qx8hd48GWVezrh7GLlMjw Jr8qMfFCH4f7fV2Kju15ZLnYH2lR0Eq5Rp489lrWdv8ZURloICuhAAa2jYLhMUm4HkRgjfmG4PaU ESgTSe8H8vkg9kL6C7Vnc9/gBw0BkctgCXyCv1tXP7fGD5cIfowJZ+DP3w9vhwZruZQzWOtHWmux kiUyIDO4CW9G0Ig0UuCfIF8KXNQty/a4UhkLuruQBwJlwvPgy2ff8GUxX2b4AiKciJbjBgKzzNIY f5spvQpRMqXphwlLwHABcrwLFxVGhQp2dzdv2aeLX5pKBezuHM032jeuJwVtQEIbTSHFE/ciLZeR BRNdB6dqzpcc2s6sC+jzIUpkxMGuIEuKSQmC4A7F56Ux1Q4S7HuQSBxIZXMrNGnPHFyXxFgQ4lbj GCiYoZ5ySr01OgI6iiYW1lNDPOzA9ZfCv8b1WocipzkPlB4snIjgvEQypCqDA12C/umOcXwOtMVH S0D0CYGJRbR+Y/BchIJYXxCK+CLsiDyjloqshhIITBND4edovYhU+BijR82QFhyWYI155EHwE4JX B2NqKyvkwSQxfqjd9VHlIzbixFJOTHPKoKDlkJJ5vjuDHKPIcMIyfiDQ/uiLpNnkhgXWO7Lw0jDN cpX0dCCE9OF+x4RpuMmsNrxs4JpyoNg78b2+eM7+rgIfIrKk7y3YLhYZiuJD6odEHYczUgiugEtl gD274dSSrlOMrRsDO9cDR6z14CErdnN5ofDECcMfkSzAnru25bmjgONhMBx+liP1DXwF7rAukjQ4 QcpkmjVLWvTzJHfI5c+kE+nCrRiPwfXSyh6Mqlgq/2i/UtuzlIZLEG5EM1q4ZXyEviwuCRmv/MAI C6Ijv2iNaGeespdMZ+NSTElYDwAxqgc4mu0h8cUvVYpoytWUT0pWsl8WEbKFic3NnrDYzBeA0X7j 3x+Y3udcwEMWrGTkXhgPsS0duZkAa18moZcFRGxLJeRD9uDRduDfFZBPG5EPiXMZLCUey4btpWEp XQFzuVc6eorOqCkl+5Ko8IgC14YgmPiD4OYZTCF4lD9AUveXFywvIvhrDiIKMYMvqWo2dnM/A0lj sUfcflAeTnrNlZZkZOC4Prg1piFA2glRH/cImz7joTIvaCyqH5WRk0vpARhJgDmPwmx2N/yXz1eD y2v20/D2u5u7IcEChD42F7pOWSWreVcLLsSYAYQMGTJlDIQ/w9DFicJc2O7YBbymkgWQAm6NwVWH kIpP3EKxf4fFy3ThyvAx2RNiAWkRBBjGQ12xTpJhbE6ybOl54JFFumKe4bCr5QhsQTqk2gUFCCOx kLi2NXUh/FTRyNTXqA6M+4djTNg1NFYLf1WffWN9+ygDbJRCNtNA+u5vPF4Wj1ek08ruOMI1XT4R 1rNWh12DMVqGfNIFSKwuP09pS3UAIoSQT+uZzsV4ZjUCIE7E48rG9Z2ZsonwBa7I0GGIca00blNC FBZEpNVGvmEJ/C/DH27eM8PBJVPq6GQ0zCUWqP8SLgR0B2ayfCZAbCoGiY+hK9Alo9lwgmqQ6ewk K6pZmRiZexMJQz6dxXDmUnoVK7e7h+M77pPrRGDY0ehr0zaPvNwg6uNoaPnU5cVFoQZdXikgw+EJ i5ACEgowAph0VSLK96PsFlGaOCdMQFDUQYl98ypvukiljPIBuumIVy+isO3XUSYWUNRrKAV0SdH1 NfzidclCyh5z0XmugLM9GKIYwykFQ7+ogAOefII9J2BRsTi588z9IiGMXsSwY1h+xaHBuPiPd3V/ vYGYRS8yRXaY+rsxKHgIdgiRPgQjSOCVcH1FpeqdC4qQgjsho/g3EYAxkCpTosYWcTzIY0QVP44B GJ1RqsQhNjH6ysW5apDqsbemoDFL/R67K7Il5I3VTFBr9nksD2KxrPXg5i+vhu/fRSp450mbe6DQ 6tF7J0L7Hdx71IK7Qj7aAAveHQcIJVgY9vObAJBABU9VjTAs08zfUECVwnFtBOLZWverNsiALaiF IAVC/UB6wcwzRUZ9TCsJO8YQLuarjOPOMCRdDrQgBsGSGTIsxKIi4xzEjVquXglJAJa2PuwOYKJC 3J9E2AMBLk4bhoQxWoQkeDegJMRZvGwRb7egSA46X6BEi8r7CXPd+ao0JHOmUxXNl4Wk4xeDZLkz +ndEUrHGiMZf+BZ3HAxnypKEf9wRLLSLZu4H7PIzMyz3hTrAWFgDgU8ISk7ABvi+sEtD3eZuhbqk aD1BRTaulUMOw1KOBoKDC+x+vM5RpKFCMBk1K+b5VYWUC45ZukJlagkxmuoFcjTOEwvv2CmalCPi ik++UgkeVTlGOxog39Edmwq7GaSPHf62F1H/mWMithhMHMCVUtsFGBJOzCVejYp3wDgM4k9aDRIz 3QyGoHBbYICbbEcS4pBFgWqc9NUElYxYSh9QAdsJoIlNdAyEVmcBCyLc9VCZKkDMI27dokbO7HJn yQo1YkOVqu6+TduzDt/8cvhmdvjGsd58/+bTm7vWenXPCImCLGIzx+g18EtVujQy3JWcEi1KDaHJ GtNphChiMJ7rCyxcjt0vJdTe1A5V6fZz6YeBpFRa+wha0yFmujRB6o3yQRgaEPZbxjPASnQ9pthw 48pSl2DaUVDaHsJHEnJwU5SLseACKO4nEGYetFLgei4WUBPnOferooONJElbFWkfQwZHXKjBFizk zHiIbk+jpv5avawNki5DWxXbvXxnaw4KtVKUWo3d2Q3NY1urYZYlSqHtDJnpt9wSWiBDPUVQvEu0 O/1+k3apZDdtYrtYzE/rvrTtKDDF1mucTFGIZ0fmgJVU7HC9vVsf2dbAHlxP0pEiGtryvMzS9iGu r4ssVybDjA4X+9J5mlP35HqJWu1KqexoRhXCJ7GtXoVB5ENqKCzsb4lFuyt094Y4mF36f8JMUt9I EkNvRS7LNOritzEIwIcd0hC946NYzzJ4AAM2yzPoHPdOa28dLNl8AQwwMNX2k+rp6NAzOEyXrunF gdvWZBS76vRa3p+V6XfPQDCgSMS4Lys+GKcAqlFz5QpQCv72Qu4LGSlvkR6Cq9IubaOB6VZqwqtm VnGXW8rwuEHPzmq81J+jGSNA7fjH2OSn+9jAo4YBtx9oMsdA8ezcsvEGwTbZOb0SaEkb3YaA451f PFjahkGaUBtvrt60jDjZERYfXByPNVXIcfUusCBGn+R6xmCsa+8KrUCUsmOanUFBOxgexKJE5b6y XpM1lNVy0ZsRkLGRB7Ya67ma7VSMSR032Bm9WqWIL22ZzHc+IiaI2SGCEo6V20UTE+2+mFEr2I8Y RrEHEiGCb7MfLEfM802Hhgc6hl2aDOLGiBudCJBEGoBmzpUC9+TgNrZgMV8qGOxguZnoJoyIadWy cnLXUb+BFmdEcH/+WXPLxg9UVgMnjgoDo2ThIR3Vm6kbLtr6Mns+Tnr0ALHGNlDTguqWLKk1XH/B A9NxOYi0MOUCAYJhjctsMl2EAT11pPZlpVt2wLTUBaNv32LDDscQN21Bg/k0FqGNLZeJ20PEQhfk rIrKY2PtpdNUsNyWnJ9C7eF8HuIyt+Fq+ptImNn6SSAmYKbHHn+SpUXRr4w7TxiYbdsgnqCL5Qmc IIQOsLkr0IVB9lrzfQ04lMDjfJZanDOEvsHlw7fxCVf1cSgYoRk3DM0KErp6vTCZZNS4Zqp/evgY cY+6YQgnLQD+DhtqjSXYj3f4HFTvrDWg4uWmEqqnrU7943Ky/tagMqyQN01dKz4qoOTmXhf/91v1 eS93oBlzYZKJmDWlE6NFBibCwzplaM1kxfGOjVOwWzCAWclohh5uTlOPHoRBUwEpJKU2JbwbHg2g i1gw8U34qvMqXW7XwojL1eBScQsfuP34tCyc/UqtO/J1R1vV7u6uClkUnhngcHDq2Mmh9wybZlS1 G9bftlqtb1lMktoM0kZUgGT6TfVIJSWE8g1zu2ujjOMdYCyf0VPEaxP7hVLpAXkYf5FbnqACh6WP 3tCVyCKjpntTpIeNUkoftHGoeWSqHLi8FO84xHDxyQ0XCS6jWGYYXwZXBovuLTYF5/QUOJXgATcj Qqy7GPuoyFHuBM+/ikBiWUjDgnHMy8jYAgDwv+1dTW/TQBDlp1g9cckhBypx4MABqkhpODQVgksU xS6xiOOA7Qah/njmzay3u+uPqHh7mydVVaLW87Le2PP5DJPPhMpz72mLuUBk44WnjTluzEfxvIA4 rol/ebSkZsYiNr8n/VY1FDPxBC1OIP1X6ueA4jXgecmetpZTHUosozEttd2WEejVuxOFtRQ3HfLH DJu+6WgvTaN324naECFYk0SNo7Uir3vo5Okh7JCafOnydSryqmrwdfNI9TGBUuKjI4EcncnosmTF adgpYZfo1ZJ0sF1iYq/jmpgEXWV8JwjkfR/Jkj8lN7fr/49n3Bx6q0IpU37S/YOzKAkvo2nJw7b4 S/qWFjy0glxXBiXn/GFAHGXidetGKm5QNMKw8Q8Wv7GzGMlycbf+tGKWqy/rxedvltPgbE8EpwWd m26FVe40dEkom9875K1NYxU4iAc+NGX7fNBY07ZtTtqxSCFqMHcbMHLnaqOt0gVG4bRtSwmrujli xiH7xV3hESmt4eRVyRVCzA+r++XyCm2l/DJZ3CX8DvFojvkf2j+7n1nd254TcXLbHl2eoIr37sn6 LC1ZnUZI2PK3jHSnAUV5Sn1oIxbF8syDX2LEJDi6FANKdDtkNWA3R/+UvJtPaCZwKG25tytxjYwR 69UJ9Y488b5zUTI0INFt/Zak7qRSwAskQgM6nCujnVh7j8eZmGN26bAgKae7sOHrXO51Vk+zw2Wf Bw7TRCnDAS4PLG5omnXkTmxHxTucsNN8Tq+yPtyJP8LrvD2MeS0Ra4t+jW7G7FrL+HZ5KRZ8gq8f l4Ygxtg2RVbvyz5lb9QkMYKxvTBUN0hQ4hjpdmEbtk5MP7tWCs1KuTa1MzzXV8X2jz9/fx1FoGC8 oi0Da2DDZUNcIf5SyEjrUtBCp3212Agh4JG8kYY1ba2S1AmSlcaqbME93Zg5knk7v+5/1mr7+41C oVAoFAqFQqFQKBQKhUKhUCgUinj4B6c0sBoAoAAA ------=OPENWEBMAIL_ATT_0.492229069673584--