Where to create an Index - Mailing list pgsql-general

From Efraín Déctor
Subject Where to create an Index
Date
Msg-id 3F5D3E1A00C044D697FCBEEBC24D4243@CMOTUM25PC
Whole thread Raw
Responses Re: Where to create an Index
List pgsql-general
I have this query:
 
SELECT ST_Distance(transform(geometryfromtext('POINT(-97.096667 18.858611)',4326),32614),C.point_geomutm)
AS DIST ,nombre FROM ciudad AS C ORDER BY DIST ASC limit 1;
 
It runs a secuential query on the table “ciudad” wich is a big table. I want to create an index but I don’t know where, using a gist index on point_geomutm does nothing and also creating one using nombre.
 
Thanks in advance.

pgsql-general by date:

Previous
From: "Welty, Richard"
Date:
Subject: 9.1.3: launching streaming replication
Next
From: "David Johnston"
Date:
Subject: Re: Where to create an Index