On Thu, Nov 29, 2007 at 01:26:00PM +, Pedro Doria Meunier wrote:
> Hi People.
>
> I need some help optimizing this query:
> I still get Seq Scans although all used fields are indexed, hence the
> time used... :-(
A seq scan on a table with 10 rows is *good*. An index would take
longer. What
Hi People.
I need some help optimizing this query:
SELECT u.friendly_name, distance(transform(u.curr_location,32628),
rc.agg_geometry) AS thedistance, u.mobile
FROM (SELECT transform(collect(r.geometry),32628) AS agg_geometry,
t.county FROM pt_madeira_roads r, pt_madeira_toponymy t
WHERE r.name
