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
