Re: help

Tony,

> I've a query which needs too many time ca. 12-15 sec.
> how can i get a better perfomance?

First of all, please take this to the PGSQL-PERFORMANCE list.

Second, see this web page:
http://techdocs.postgresql.org/guides/SlowQueryPostingGuidelines

> explain select o.id from ioobeject o,dist_vertron v where
> macro_lid=1123 and         (o.id=v.id) and (o.deleted<>'1') and
> (o.status='activo')  order by o.ort;

Third, from your explain, ioobject and dist_vertron are obviously somewhat 
complex views.   We need those view definitions, possibly plus schema for the 
underlying tables (including indexes), or we can't help you.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco