Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UOmjA-0002we-3m for pgsql-performance@arkaria.postgresql.org; Sun, 07 Apr 2013 10:21:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UOmj9-0005Mm-GR for pgsql-performance@arkaria.postgresql.org; Sun, 07 Apr 2013 10:21:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UOmj7-0005Me-A3 for pgsql-performance@postgresql.org; Sun, 07 Apr 2013 10:21:33 +0000 Received: from nm19.bullet.mail.ne1.yahoo.com ([98.138.90.82]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UOmix-00055r-0B for pgsql-performance@postgresql.org; Sun, 07 Apr 2013 10:21:32 +0000 Received: from [98.138.90.55] by nm19.bullet.mail.ne1.yahoo.com with NNFMP; 07 Apr 2013 10:21:20 -0000 Received: from [98.138.89.246] by tm8.bullet.mail.ne1.yahoo.com with NNFMP; 07 Apr 2013 10:21:20 -0000 Received: from [127.0.0.1] by omp1060.mail.ne1.yahoo.com with NNFMP; 07 Apr 2013 10:21:20 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 618598.8928.bm@omp1060.mail.ne1.yahoo.com Received: (qmail 67728 invoked by uid 60001); 7 Apr 2013 10:21:20 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1365330080; bh=HfneC7dW6ASfIsB9j8E66N2iN0CM5PF5b9BZeLQst3Q=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=xCP3FUXHDCws+8AEr2xu4i2pivzaGsSu1G9Ms9WogMrnlDNtn6tX/lTbynxCMtegU8y20LOWqzVhkvtxF5NEd28xDSjHjfU+aUx6wHPamSZHtOhQ3SW/+zWi1GsqaN7mnDtarU0xdL1qEJUbK3ZkyPPKfbek96Jn/6jFVvqRPeg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=W+8X2BKBws0b7kw8OWMKTq8jo8dlzm+U4/tmhWXuxc3h/tSoH12uInHKnk4Nbt+nvf1nI4wA83tQ1z4l+67H9TQe48YfHvq+i6Ij2UVhgc8w1CanmK+OeiS0f0uCJZ35cxJ00KfGT6IzMkHdfA7oWQE+prJtPEoL2DFvZ6mY5Ig=; X-YMail-OSG: QGzsma4VM1mCwOdUTgdQs6Ra0oZf4hR5X9ead6Q2nyVn7sH iUp42k6uSjN9SWWowVUMb8d7JSLhgFoUsPRjS2mVrGbodlIA.hEJGMkZPZKZ WXISX532scB3unzlgaA2pQI3qWhvZYAzksqlgy9GAq8_OSP0lFOxxSxrm0eO mIqKTZCG7YzuNDAjyfAc34Ypux4U5buyOxzgyTqA.aba8J1PvR28uqDuzfgN LChDmD_kSTdI5UG89bd4t0zCWdXi0F3t.L1NN5bW08Sp33Iwt5hM2SD7HYAj DRgHDjYlzK0xsOeFHtKAvOz7o6x.9AFMe7F.WWDKxtbz2p7hQ8i26a_jqUR6 mLbEHJWSGaZl483.jAKzaPgpGfQ3SXe8bW2zl6ZUCXykk6xsE8lU_5FZBrly 4CCTovTr6rwhmTvWZ6L6sST53LW23vzQcMzCaLSvTLHAZrTF8tAgl_mTyGn1 BcNGZP9aPj1frRBZlTgEWDTfEihvJhCKUeaFTtAHTmHUThml6uFrrpzqff1_ y8Y.mYipFiMdGb.EDwB51tOfPmUa5 Received: from [98.210.146.78] by web125903.mail.ne1.yahoo.com via HTTP; Sun, 07 Apr 2013 03:21:20 PDT X-Rocket-MIMEInfo: 002.001, PiBUaGFua3MgZm9yIHlvdXIgcmVzcG9uc2UuIEkgdHJpZWQgZG9pbmcgd2hhdCB5b3Ugc3VnZ2VzdGVkIHNvIHRoYXQgdGFibGUgbm93IGhhcyBhIHByaW1hcnkga2V5IG9mICcgQ09OU1RSQUlOVCBkYXRhX2FyZWFfcGtleSBQUklNQVJZIEtFWShhcmVhX2lkICwgZGF0YV9pZCApOyAnIGFuZCBJJ3ZlIGFkZGVkIHRoZSBJTkRFWCA.IG9mICdDUkVBVEUgSU5ERVggZGF0YV9hcmVhX2RhdGFfaWRfaW5kZXggT04gZGF0YV9hcmVhIFVTSU5HIGJ0cmVlIChkYXRhX2lkICk7JyB1bmZvcnR1bmF0ZWx5IGl0IGhhc24BMAEBAQE- X-Mailer: YahooMailWebService/0.8.140.532 References: <1365179846.6562.YahooMailNeo@web162903.mail.bf1.yahoo.com> Message-ID: <1365330080.67650.YahooMailNeo@web125903.mail.ne1.yahoo.com> Date: Sun, 7 Apr 2013 03:21:20 -0700 (PDT) From: Greg Williamson Reply-To: Greg Williamson Subject: Re: INDEX Performance Issue To: Mark Davidson , Kevin Grittner Cc: "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Pg-Spam-Score: -3.9 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org > Thanks for your response. I tried doing what you suggested so that table now has a primary key of ' CONSTRAINT data_area_pkey PRIMARY KEY(area_id , data_id ); ' and I've added the INDEX > of 'CREATE INDEX data_area_data_id_index ON data_area USING btree (data_id );' unfortunately it hasn't resulted in an improvement of the query performance. Here is the explain > ... Did you run analyze on the table after creating the index ? GW -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance