Re: Noobie: Problems with a query - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Noobie: Problems with a query
Date
Msg-id 1056974334.6646.0.camel@billy
Whole thread Raw
In response to Noobie: Problems with a query  ("Chris Boget" <chris@wild.net>)
List pgsql-novice
Am Mon, 2003-06-30 um 13.56 schrieb Chris Boget:
> which, sadly, is greek to me.  The problem is that the above query
> takes very close to 12 seconds to execute.  Is there a better way I
> could write the query?  The number of rows in each table are as
> follows:

First of all you should try: VACUUM ANALYZE;

HTH
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: "Chris Boget"
Date:
Subject: Noobie: Problems with a query
Next
From: "Chris Boget"
Date:
Subject: Re: Noobie: Problems with a query