Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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
=:->

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group