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
