Re: Queries slow using stored procedures

From: John Meinel <john(at)johnmeinel(dot)com>
To: Rod Dutton <rod(at)e-rm(dot)co(dot)uk>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Queries slow using stored procedures
Date: 2004-10-24 19:11:49
Message-ID: 417BFE75.4060006@johnmeinel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Rod Dutton wrote:
> I also should add that the sp is only slow when the table is big (probably
> obvious!).
>
> Rod

Sure, the problem is it is switching to a sequential search, with a lot
of rows, versus doing an indexed search.

It's all about trying to figure out how to fix that, especially for any
value of botnum. I would have hoped that using LIMIT 1 would have fixed
that.

John
=:->

Browse pgsql-performance by date

  From Date Subject
Next Message John Meinel 2004-10-24 19:27:59 Sequential Scan with LIMIT
Previous Message John Meinel 2004-10-24 19:08:59 Re: Queries slow using stored procedures