PROTECTED]
Sent: Friday, April 27, 2007 5:57 PM
To: Listmail
Cc: John Cole; 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Query in function not using index...
Listmail <[EMAIL PROTECTED]> writes:
>> Any idea why using a variable v_streetName instead of a string &#
Hello,
I need some help with a query inside a function. The table has 31M rows
in it (us streets), and a select statement takes 10ms when using an index
built for the query...
But, when the same query is in a function and uses a variable the index
isn't used and the query takes a few minutes.
6MB
Max_fsm_pages is 204800
Max_connections is 50
Any help would be greatly appreciated.
Thanks,
John Cole
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.2/692 - Release Date: 2/18/2007
4:35 PM
This email and any files tra
