On Thu, 7 Dec 2006, Tom Lane wrote:
Richard Ray <[EMAIL PROTECTED]> writes:
On Thu, 7 Dec 2006, Thomas Pundt wrote:
Just a guess: is the column "doc_num" really of type text? Maybe using "text"
in the function lets the planner choose a sequential scan?
Actually "doc_num" is char(9)
I changed text to char(9) and got same slow results
You need to make the second argument type "name", too, if you have a lot
of users.
I said my knowledge was pitiful
Changing both parameters to char(9) and name fixed the problem
It appears to be using the index
If time allows could you explain this a bit
Thanks
Richard
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
