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 purposes. We can perform the following steps:
Run PGAdmin III.
Navigate to File |
postgresql.conf.When the file dialog is opened, navigate to the
C:\Program Files\PostgreSQL\9.3\datadirectory and select thepostgresql.conffile. You will see a window...