Re: SQL stupid query plan... terrible performance ! - Mailing list pgsql-performance

From Jeff
Subject Re: SQL stupid query plan... terrible performance !
Date
Msg-id 9ADF62CA-C8AD-11D8-A320-000D9366F0C4@torgo.978.org
Whole thread Raw
In response to SQL stupid query plan... terrible performance !  (Jim <jim.jim@wp.pl>)
List 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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


pgsql-performance by date:

Previous
From: Jim
Date:
Subject: SQL stupid query plan... terrible performance !
Next
From: "Bill"
Date:
Subject: Query performance