Re: sub-query optimization

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Brad Hilton <bhilton(at)vpop(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: sub-query optimization
Date: 2003-02-17 18:11:44
Message-ID: 3E5125E0.3020103@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-02-17 19:52:01 Re: PL/PGSQL EDITOR
Previous Message Brad Hilton 2003-02-17 17:20:07 Re: sub-query optimization