Another important thing that we can do to speed up our database is to adjust some of the parameters that PostgreSQL's DBMS uses. We have to configure new values for them, keeping in mind the specific features of spatial databases (spatial records are usually bigger than nonspatial ones). Now, we will see how to make these changes.
In order to do this, we will have to edit the
postgressql.conf file. It's a
postgreSQLconfiguration file and we can find it in the
C:\Program Files\PostgreSQL\9.3\data folder.
There are two ways of performing this task; the first is to open it with a text editor, such as Notepad, the second one is to open it using the utility that comes with PGAdmin for these ...