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/