Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6F1CA9FB42F for ; Sat, 19 May 2007 19:08:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 61720-10 for ; Sat, 19 May 2007 19:08:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.239]) by postgresql.org (Postfix) with ESMTP id 5214F9FB40E for ; Sat, 19 May 2007 19:08:09 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id s1so1824397nze for ; Sat, 19 May 2007 15:08:08 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Fe36JoSKhaJ+HHYn30N/x2oACVVXukoXyxVr9vhER2xRu/Tbi4DLcZceTBuyD/cAe9oTqQwq4zzWVi6IY7pGDbj4ESX8lMD7xXCainMSS/3j9Dg/EoLDiOjtSKMS79HgjemR0l/VDbGrOM1/JWkZXLLEuTAabUa0Gr6JKiVK7PM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=ajAyF9S1KowRqUk1qLqVRIGOSqANJ74xyDg4i20wzPRAgnH+r2ez3slQ4Gqg4EYyDUVSoG0IiohUPu0EakxF4+rD7fmSZGotVGDdKKHTzpG9PDxLRNFaRLSXHfA10hFH7ylbC+I27CWex2hiTuSM3hIRx0Ji/yilxU3B40Me/GE= Received: by 10.114.12.9 with SMTP id 9mr1689514wal.1179612487528; Sat, 19 May 2007 15:08:07 -0700 (PDT) Received: by 10.114.93.12 with HTTP; Sat, 19 May 2007 15:08:07 -0700 (PDT) Message-ID: <24b53fa00705191508i36fbf192me7152c79bf2ec50f@mail.gmail.com> Date: Sat, 19 May 2007 15:08:07 -0700 From: "s d" To: pgsql-performance@postgresql.org Subject: QP Problem MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/372 X-Sequence-Number: 24762 Hi, I have about 6 tables that inherit from one table. They all have the exact same indexes but when i try to query all by a row (which is indexed, btree) the QP decides to do sequential scan for some of them (the bigger tables) rather than use the index. Any ideas why that may happen? I am using postgres 8.2 Thanks, S.