O'Reilly logo

PostGIS Essentials by Angel Marquez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tuning PostgreSQL's configuration file for our spatial database

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required