pgsql_tmp and postgres settings - Mailing list pgsql-performance

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