[PERFORM] Optimize the database performance

Hi, I've a postgres 9.1 database used for map generating ( tiles ). The system has 24Go RAM and 5 processors. I'm using geoserver to generate the tiles. My data used 8486 MB = psql -d gis -c SELECT pg_size_pretty(pg_database_size('gis')) I've carefully indexes the table by the the_geom column.

Re: [PERFORM] Optimize the database performance

hello Micha, i think that noone can tell you much without more information about your system. roughly i would say that you could change the following parameters: shared_buffers = 1024MB - 6GB work_mem = 256MB - 30-50 MB effective_cache_size = 5120MB - 16GB (depends on whether its a dedicated db

Re: [PERFORM] Optimize the database performance

On 10/17/2011 04:48 AM, Micka wrote: Hi, I've a postgres 9.1 database used for map generating ( tiles ). The system has 24Go RAM and 5 processors. I'm using geoserver to generate the tiles. My data used 8486 MB = psql -d gis -c SELECT pg_size_pretty(pg_database_size('gis')) I've carefully

Re: [PERFORM] Optimize the database performance

2011/10/17 Micka mickamus...@gmail.com: Hi, I've a postgres 9.1 database used for map generating ( tiles ). The system has 24Go RAM and 5 processors. I'm using geoserver to generate the tiles. My data used 8486 MB  = psql -d gis -c SELECT pg_size_pretty(pg_database_size('gis')) I've