From: Tony Simbine <jantos-work@mvweb.de>
To: pgsql-sql@postgresql.org
Cc: Josh Berkus <josh@agliodbs.com>
Subject: Re: help
Date: Tue, 17 Jun 2003 13:28:16 +0200
Message-ID: <3EEEFB50.1070908@mvweb.de> (raw)
References: <3EE88B1F.2050003@mvweb.de>
<200306121010.45479.josh@agliodbs.com>
Josh,
thanks for your help.
Josh Berkus wrote:
> 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
i read some tips on the above pages and my database and all my
queries run very well.
i've optimized the queriey from where ... IN (select ..) to EXISTS
and I've done vacumdb full.
my requests last between 0.009 to 0.2 sec compared with 12-15 sec.
i'm very happy.
thanks very much.
tony
>
>
>>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.
>
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: jantos-work@mvweb.de, josh@agliodbs.com
Subject: Re: help
In-Reply-To: <3EEEFB50.1070908@mvweb.de>
* 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