From: Josh Berkus <josh@agliodbs.com>
To: Tony Simbine <jantos-work@mvweb.de>
To: pgsql-sql@postgresql.org
Subject: Re: help
Date: Thu, 12 Jun 2003 10:10:45 -0700
Message-ID: <200306121010.45479.josh@agliodbs.com> (raw)
In-Reply-To: <3EE88B1F.2050003@mvweb.de>
References: <3EE88B1F.2050003@mvweb.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, jantos-work@mvweb.de
Subject: Re: help
In-Reply-To: <200306121010.45479.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox