Fix issue with SDW running slow or unable to open tables

Overview

If you are finding the speed of your Spatial Data Warehouse (SDW) slow or maybe you cannot open SDW tables, then the following steps could help resolve the problem.

Step-by-step guide

You could simply restart the Windows Service or reboot the Server itself or you can try to identify the session that is causing the problem.

  • Log onto your SDW using pgAdmin and connect to the database as the Posgres user.
  • Run the following SQL which will list all of the current running sessions.

  • You can cancel the running session using the following SQL where procpid is the procpid value for the session from the previous query.