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 



FROM table

where ID IN(SELECT tblID FROM Table2)

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 8 mths agoLast active
  • 20Views
  • 1 Following