Re: Join Bad Performance on different data types

On Tue, Mar 4, 2014 at 4:19 PM, Adarsh Sharma <eddy(dot)adarsh(at)gmail(dot)com> wrote:

> Is dere any way i can rewrite the query so that i need not to set
> seqscan-off, because i dont want to embed one more line in application
> code and also dont want to change global setting in postgresql.conf to
> disable seqscan.
>

You can use a specific user for this query and set parameter's value at
user level.

But if you don't have any way of doing that then you pretty much have to
"embed one more line in application code" [though I have never understood
why application teams do not want to do that]. It should be fine, unless
you are developing a product which can be used with someother RDBMS and
hence you don't want to introduce a PostgreSQL specific line in code.

Best Regards,

*Sameer Kumar | Database Consultant*

*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533

M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com

*[image: icons]*

[image: Email patch] <http://www.ashnik.com/>

This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).