[Geodata] Tiger - can't get SQL to use indexes in postgres

[Wolf Bergenheim]

On 23.06.2008 19:14, Stephen Woodbridge wrote:
> 
> Any thoughts on speeding this up?
>   -Steve 

> select count(*) from addr a, addrfn b, featnames c where a.arid=b.arid and b.linearid=c.linearid;

Have you tried natural joins instead? It _should_ be faster then a 
select using only where.

select count(*) from addr natural join ( addrfn natural join featnames )

--Wolf

-- 

<:3 )---- Wolf Bergenheim ----( 8:>