From: | Micka <mickamusset(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Optimize the database performance |
Date: | 2011-10-17 09:48:35 |
Message-ID: | CAF+MRtnRr_8QqZ5ZGz0_H8jzvn8KND=K7cVzX8aywiumN+UJwA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-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.
Here is my database config :
--> change :
--> listen_addresses = '*'
--> max_connections = 50
--> tcp_keepalives_idle = 60 # TCP_KEEPIDLE, in seconds;
--> shared_buffers = 1024MB # 10% of available RAM
--> work_mem = 256MB # min 64kB
--> maintenance_work_mem = 256MB # min 1MB
--> effective_cache_size = 5120MB
--> autovacuum = off
sudo nano /etc/sysctl.conf
--> kernel.shmmax=5368709120
--> kernel.shmall=5368709120
I wanted to have your opinion about this config ? What can I do to optimize
the performance ?
Thank you,
From | Date | Subject | |
---|---|---|---|
Next Message | MirrorX | 2011-10-17 10:39:26 | Re: Optimize the database performance |
Previous Message | Robins Tharakan | 2011-10-17 06:28:47 | Bad plan by Planner (Already resolved?) |