PostgreSQL Performance Issue
I seem to be having performance issues whilst executing Postgres Queries.
I have a PostgreSQL DB running on AWS, if I run a simply query from a desktop query via a desktop client the query executes in milliseconds. If I run the very same query in mode using the same credentials and connection the query takes 10 mins plus.
Anyone have any ideas?
ps. The query is
where ID IN(SELECT tblID FROM Table2)