Re: SQL stupid query plan... terrible performance !

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Jim <jim(dot)jim(at)wp(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SQL stupid query plan... terrible performance !
Date: 2004-06-28 02:48:16
Message-ID: 9ADF62CA-C8AD-11D8-A320-000D9366F0C4@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jun 27, 2004, at 8:37 PM, Jim wrote:

> Hi,
>
> I have one performance issue... and realy have no idea what's going
> on...
> When I set enable_seqscan to 0, query2 runs the same way...
>
> upload => 60667 entities
> uploadfield => 506316 entities
>

Have you vacuum analyze'd recently?

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bill 2004-06-28 03:26:19 Query performance
Previous Message Jim 2004-06-28 00:37:33 SQL stupid query plan... terrible performance !