Re: INDEX Performance Issue

From: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
To: Mark Davidson <mark(at)4each(dot)co(dot)uk>, Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: INDEX Performance Issue
Date: 2013-04-07 10:21:20
Message-ID: 1365330080.67650.YahooMailNeo@web125903.mail.ne1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Franck Routier 2013-04-07 12:12:33 Re: What happens between end of explain analyze and end of query execution ?
Previous Message Mark Davidson 2013-04-07 10:03:28 Re: INDEX Performance Issue