Re: sub-query optimization - Mailing list pgsql-sql

From Tomasz Myrta
Subject Re: sub-query optimization
Date
Msg-id 3E5125E0.3020103@klaster.net
Whole thread Raw
In response to sub-query optimization  (Brad Hilton <bhilton@vpop.net>)
List pgsql-sql
Brad Hilton wrote:

> --------------------------------
>  Merge Join  (cost=26538.07..30754.75 rows=20000 width=191) (actual
> time=1736.36..3079.64 rows=100000 loops=1)

It looks like you didn't vacuum analyze database before explain analyze. 
Can you do this and send explain analyze once again?
Look at the "actual time" showing which operation takes the most time.

Regards,
Tomasz Myrta




pgsql-sql by date:

Previous
From: Brad Hilton
Date:
Subject: Re: sub-query optimization
Next
From: jasiek@serwer.skawsoft.com.pl
Date:
Subject: Re: sub-query optimization