Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id A5B5B632FC1 for ; Tue, 2 Feb 2010 06:54:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 45078-01 for ; Tue, 2 Feb 2010 10:54:09 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ey-out-2122.google.com (ey-out-2122.google.com [74.125.78.25]) by mail.postgresql.org (Postfix) with ESMTP id 9F610633F43 for ; Tue, 2 Feb 2010 06:51:58 -0400 (AST) Received: by ey-out-2122.google.com with SMTP id 9so1081084eyd.33 for ; Tue, 02 Feb 2010 02:51:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=cOHEwzeITedZSqVXjk8K4Wcy/ioPnRiz+xq+NStx9Og=; b=jMuKp6Q5gHlFTIYJtVw4/h0FCSmRx2YlZwObut9E77+9EhZQG77iX/QXEVXxUIib+O kI/ga6JOBM8ztcVitPLh6eDaCjmNwJmoBZUznnqVbjbaYDuOYEXWv7cO5858Szj20/+U Zdi4a5m3av5vr3kOS9QD9A6wv4O4qa29pTGFU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=CLui7rQs4/ExNCZNHc/RImh9sWeV8odcMtCuDjtJN2jsu4ZR8dJS53wuP/b0kuV7s3 9NddwiQ4UmvC6Z/5W9JHgDggEl2uxzqCOm4nOJEEP1kbjcUBGagHLAhW2NibhdqmrN5J elncybN1u+bFbGPfwcFyHYMC9e6j+xnWStjkw= MIME-Version: 1.0 Received: by 10.213.1.23 with SMTP id 23mr5420936ebd.98.1265107917333; Tue, 02 Feb 2010 02:51:57 -0800 (PST) Date: Tue, 2 Feb 2010 11:51:57 +0100 Message-ID: Subject: How to increase postgresql performance From: fida aljounaidi To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=000e0ce03eda03e3fe047e9be4d8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5 tests=BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201002/13 X-Sequence-Number: 33616 --000e0ce03eda03e3fe047e9be4d8 Content-Type: text/plain; charset=UTF-8 Hi I have an sql query which takes 20 seconds to be executed. this sql query contain more than 870 id under the select where in () condition. So , it is not a large row result but a big list of conditions to be crossed. I'm using postgresql 8.4. Thanks for help --000e0ce03eda03e3fe047e9be4d8 Content-Type: text/html; charset=UTF-8 Hi

I have an sql query which takes 20 seconds to be executed.

this sql query contain more than 870 id under the select where in () condition.

So , it is not a large row result but a big list of conditions to be crossed.

I'm using postgresql 8.4.

Thanks for help


--000e0ce03eda03e3fe047e9be4d8--