Hello,
During insert or update, potgresql write in pgsql_tmp directory and so
performance are very poor.
My configuration is:
Work mem 10240
Effective_cache_size 30000
Shared buffers 9000
Max_fsm_pages 35000
Wal Buffers 24
Autovacuum on
Manual vacuum analyze and vacuum full analyze every day
Server:
1 Xeon processor
2500 MB ram
Red Hat Enterprise ES 3
Postgresql (RPM from official website) 8.1.0
Tables are vacuumed frequently and now fsm is very low (only 3000 pages).
Updates and inserts on this database are infrequent, and files to import
aren't so big (7-50 Mb for 2000-20000 record in a txt file).
On this server are installed and active also Apache - Tomcat - Java 1.4.2
which provide data to import.
Tables interested have only max 4 index.
Are parameters adapted?
Thanks
Domenico Mozzanica