Re: Speeding up a query. - Mailing list pgsql-performance

From Grzegorz Jaśkiewicz
Subject Re: Speeding up a query.
Date
Msg-id 2f4958ff0906170140q673ba1c6jf8eff4aa42798a22@mail.gmail.com
Whole thread Raw
In response to Re: Speeding up a query.  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-performance
On Wed, Jun 17, 2009 at 8:33 AM, Albe Laurenz<laurenz.albe@wien.gv.at> wrote:

>
> I don't understand your data model well enough to understand
> the query, so I can only give you general hints (which you probably
> already know):

He is effectively joining same table 4 times in a for loop, to get
result, this is veeery ineffective.
imagine:
for(x)
  for(x)
    for(x)
     for(x)
..

where X is number of rows in table matrix. not scarred yet ?

--
GJ

pgsql-performance by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: 8.4 COPY performance regression on Solaris
Next
From: Alberto Dalmaso
Date:
Subject: Re: Speeding up a query.